Sort with Partial Text Match

I've figured out how to sort in Excel but that doesn't work for partial text areas of a cell. What I need to do now is sort or group together the cells that have a partial text match and then delete them.

I have 237 email addresses that I want to send pictures to, but I don't want to send to people on AOL. I want to delete the cells that have the '@aol.com' addresses in them. Is there a quick way to do this with a function or otherwise?

Thanks, I'd really appreciate the help!

Kim Fenolio

Use a "dummy" column to achieve this. The formula in the dummy column would be:

Please Login or Register  to view this content.

where A2 is the cell with the email address.
Copy the formula down then do a descending sort on the column. The cells that have the #VALUE! (or a non aol.com address) will sort to the top of the column