try data filter
datafilterautofiltercustomdoesnotcontain @

--
Don Guillett
SalesAid Software

"la90292" wrote in message
...
My customer base of 5,000+ records (columns a-l) has some invalid email
addresses in column g. The "@" is missing. I would like to have those
particular email addresses sorted at the beginning of the list so that I
can
go through them and see if they can be corrected or deleted.

Which formula would work best for this project?

Thanks for your help.

Best regards,
victor