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.