Macro

[hmadeley]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi all, looking for help with macros.

I have thousands of pages in excel of text i have copied from a document.

I am looking for someone to show me how to extract all the email addresses in the document. I need the whole thing eg "(e-mail address removed)" and if possible, move to a new column/document.

Any help would be much appreciated!

Thanks in advance

Harry

 

[Bob Greenblatt]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi all, looking for help with macros.

I have thousands of pages in excel of text i have copied from a document.

I am looking for someone to show me how to extract all the email addresses in
the document. I need the whole thing eg "(e-mail address removed)" and if possible,
move to a new column/document.

Any help would be much appreciated!

Thanks in advance

Harry

A whole lot depends on hoe the "thousands of pages" are structured. Are they
separate workbooks? Sheets in a workbook? How is the text distributed in the
cells?

If you send me a better description of what you have and what you want, I'll
be happy to provide a quote.

 

[hmadeley]

Thanks for your swift reply Rob,

But i have worked out another way!

Just using Auto Filter to select any "@" words!