Code to extract E-Mail addresses

[Dazzawm]

I have thousands of rows with email addresses in column A. Problem is they are amongst other text at the beginning, middle or end. Can a code be made please to extract the email addresses in to column B next to it? I haven't posted an example as for security and its pretty self explanatory.


Thanks if you can help.

 

[gaz_chops]

I think to get an answer you need to provide some examples of the data structure, you can change anything that is sensitive.

 

[Dazzawm]

By the way in can't be done by looking for the @ because some are like this

A2
[TABLE="width: 447"]
<tbody>[TR]
[TD="class: xl63"]Darrens twitter is @Example and his email is example@gmail.com

[/TD]
[/TR]
</tbody>[/TABLE]

So example@gmail.com will need extracting to B2[TABLE="width: 447"]
<tbody></tbody>[/TABLE]

 

[Dazzawm]

I really hope someone can come up with a solution as this is so important to me.

 

[hiker95]

Dazzawm,

It is always easier to help and test possible solutions if we could work with your actual file.

Perhaps you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com.

Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here.

Include a detailed explanation of what you would like to do referring to specific cells and worksheets.

If the workbook contains confidential information, you could replace it with generic data.

 

[Dazzawm]

Dazzawm,

It is always easier to help and test possible solutions if we could work with your actual file.

Perhaps you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com.

Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here.

Include a detailed explanation of what you would like to do referring to specific cells and worksheets.

If the workbook contains confidential information, you could replace it with generic data.

I will do that but I really didn't think it was necessary for this one. There are emails in column A amongst other words and they need copying or taking out to column B

 

[gaz_chops]

The problem, in my experience, is that not posting a sample will result in less help & hundreds of questions!

 

[Dazzawm]

Hope this helps. Excel Jeanie and HTML maker won't seem to install. I have put in bold what would need copying in to B

[TABLE="width: 715"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]Darrens twitter is @Example and his email is example@gmail.com[/TD]
[TD]example@gmail.com[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Can you tell me whos email example@hotmail.co.uk is please[/TD]
[TD]example@hotmail.co.uk[/TD]
[/TR]
</tbody>[/TABLE]

 

[Dazzawm]

Sorry it is vague like i said i haven't been able to install excel jeanie or html maker to make it easier.

 

[Macropod]

It is always easier to help and test possible solutions if we could work with your actual file.

Perhaps you could upload a copy of your file to a free site such

Kindly don't promote the use of off-site file hosting. Such links are prone to failure in the longer term. Instead, users should employ the posting aids provided by this site, which is usually quite sufficient. See: http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html
Off-site file hosting should be countenanced as a last resort only, not as the first resort.