This question told me to ask my excel question here: http://meta.stackexchange.com/questions/90919/which-stack-exchange-site-is-best-for-microsoft-excel-questions
I'm actually using libre calculator.
I have a spreadsheet where column G is supposed to be only email addresses. In Libre Calculator, how do I perform the equivalent of the following sql statement?
DELETE FROM spreadsheet WHERE g NOT LIKE '%@%'
This is my way of quickly deleting row with clearly erroneous emails.