| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to Sort Invalid Email Addresses?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort in excel using end of email address | Excel Worksheet Functions | |||
| Change email addresses | Excel Discussion (Misc queries) | |||
| email addresses in cells | Excel Discussion (Misc queries) | |||
| How do I input email addresses in Excel without the hyperlink, | Excel Discussion (Misc queries) | |||
| How do you sort a column of email addresses by domain name in Exc. | Excel Discussion (Misc queries) | |||
Threaded Mode
