Find Email Address in a text file

M

matt4003

Hello,

I am having a small issue. I received a text file from a co-worker
over seas that contains all his outlook contact information. I have
opened it in excel using CSV. There are thousands of rows and anout
100 columns, problem is that the email address do not all fall in the
same column or row. I need to be able to locate each email address and
copy just the domain (@yahoo.com for example) into a single
column.....does anyone have any suggestions??

Thanks,
Matt
 
M

matt4003

Hi Jason,

Thanks for the reply...still have a question about your solution.

How does this solution work? How does it encompase the whole sheet?
Or maybe I just don't understand how to use it. Do I put it into
cell, or do I put it into a macro, if so what should the rest of th
macro look like??

Thanks,
Mat
 
Top