Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

Filter and select for ColumnG contains @ then delete rows.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .