So I have a contacts spread sheet with about 3000 emails. The problem is that the column with the emails also has company names & websites in the same cells. Is there a way to select just the emails in the document so I can copy them over to a dedicated column?

Ive tried opening the spread sheet in word & using the "find & replace" feature and I managed to select every "@" in the document. However I cannot select the whole word containing "@" (or at least I dont know how to).

Some help with this dilemma will be greatly appreciated! I REALLY do not want to go through each email individually.



I also have Outlook if that helps.

This could certainly be done with a formula or a script in Excel. Do you have a sample of the 3000 rows. This is so we can know how to extract the string.

Thanks

Quite easily done in Word. If you have a document with email addresses in:

• Word's hyperlink format (i.e. clickable hyperlinks, not plain text), you can use a wildcard Find/Replace, with:
Find = <[^1-^31\!-\?A-ÿ]{1,}[!\@][^1-\?A-ÿ]{1,}
Replace = nothing

• plain text, you can use a wildcard Find/Replace, with:
Find = <[0-9A-ÿ.\-]{1,}\@[0-9A-ÿ\-.]{1,}([^13 -/\:-\@\\-`\{-¿])
Replace = \1

Afterwards, you should have a file with only email addresses in it (and maybe the odd @ and the following word if you have any loose @ characters in the data).

So, if you copy the cells to Word and use whichever Find/Replace approach applies to your data, you should then be able to copy the cleaned data back to Excel.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]