Find Email Address in a text file

  • Thread starter Thread starter matt4003
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find Email Address in a text file 2
counting blank cells within two columns 2
Email addresses in a comma-delimited (CSV) file 1
Email addresses 2
deleting rows that is compared to a single column. 1
Macro to convert email address to web address? 4
Exporting email addresses 3
Puzzling quotes around text 2

Back
Top