How to delete rows in Pages with a box ending in an @ sign

[meddyliol]

In Pages I have a very large spreadsheet. In Cell B I have email addresses, some of which I have already deleted everything after the @ sign. I need to delete every row that contains this. Doing this by deleting manually is getting on my wick. There must be a quick way of doing this. Some of the boxes in Cell B contain something like plonker@. These are the rows I need to get rid of.

Any help would be appreciated

Brian

 

[Slartibart]

This is in Pages or in Numbers? In Numbers Smart Categories (a.k.a. Pivot tables) may be your friend here - the extra data is in a particular column then you can 'Add Category for ...' that column and all the rows with that data will be grouped. You then should be able to select and delete them.

 

[meddyliol]

Sorry, I don't know why I said Pages, it should be Numbers of course. Thanks for your help, will have a look at what you suggest.