Sort out all mail adresses from massive excel file

**TomISR** · 04-20-2010, 09:41 AM

Dear users,

I have a massive excel file containing all kind of data in different cells over the place. I would like to extract only those cells containing e-mail adresses. Does anyone have a solution for me? If it is a VB solution that's ok too, but i'm quite unexperienced as far as VB goes so please make it easy to work with.

Thanks very much in advance!!!!!

(using excel 2003)

**davesexcel** · 04-20-2010, 08:32 PM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

**TomISR** · 04-21-2010, 05:22 AM

This is a dummy of the file I'm tryin to modify. As you can see the first two sheets contain all sorts of data. In my actual file I have about 60 of these sheets. Now I'm trying to just extract all the mail adresses from all sheets and get a result as shown in sheet 3.

thanks in advance!