Searching for Missing Characters in Excel
February 9, 2010 12:32 PM   Subscribe

I have a spreadsheet that includes a field for email addresses, but I know for a fact that some of the addresses are incomplete for one reason or another. I want to search that column for any entries missing the @ symbol and delete those entries. Can this be pulled off in Excel? I'd do it manually but the list is 8,000 strong.
posted by moviehawk to Computers & Internet (1 answer total)

This post was deleted for the following reason: at poster's request -- mathowie

 
In the next column you can create a formula =find("@",A1). This will return an integer if there is a @ within A1, and otherwise an error. Then you can sort by that new column and all the errors will be together, and you can delete them.
posted by Perplexity at 12:38 PM on February 9, 2010


« Older What is the definitive reference work for birth...   |   Can I REALLY get a bunch of 18-year-olds to dig... Newer »
This thread is closed to new comments.