- Joined
- Jan 3, 2010
- Messages
- 1
- Reaction score
- 0
Hi,
I am fairly inexperienced with excel, I have no idea on how to use macros and have only a little knowledge of simple formulas. I was wondering weather someone can help me with the following task of extracting email addresses from a column and copying them to another column.
I currently have an excel document with one very long column (A) (8000+ rows). The data in these rows are mixed full of characters and numbers, also there are valid email addresses. The email addresses do not appear in any particular order.
I need to extract these email addresses and copy them into column B.
Using the simple search facility I know that I have more than 600 email addresses in this document.
Can someone help with this?
Many Thanks
MT
I am fairly inexperienced with excel, I have no idea on how to use macros and have only a little knowledge of simple formulas. I was wondering weather someone can help me with the following task of extracting email addresses from a column and copying them to another column.
I currently have an excel document with one very long column (A) (8000+ rows). The data in these rows are mixed full of characters and numbers, also there are valid email addresses. The email addresses do not appear in any particular order.
I need to extract these email addresses and copy them into column B.
Using the simple search facility I know that I have more than 600 email addresses in this document.
Can someone help with this?
Many Thanks
MT