Extract email address

[winmaxservices1]

Hi,

I have data in sheet1


it contains numbers, email address, formulas etc. in different cells. I need VBA code to extract only email address in new in new sheet(Sheet2) in Col-A

[Richard Buttrey]

Hi,

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

[Alf]

Perhaps like this?

Please Login or Register  to view this content.

Alf

[winmaxservices1]

Hi, attached sample file. data is in sheet1 and result is in sheet2