Solved what vba routine can I use to separate email addresses

December 31, 2019 at 08:28:51
Specs: Windows 10
the data is in one cell,
I want to separate all email addresses and put them in another row where they will be written cell by cell

the data is like this
conrad@abc.com;sample1@cbd@com;sample2@ghi.com

the result should

conrad@abc.com
sample1@cbd.com
sample2@ghi.com


See More: what vba routine can I use to separate email addresses

Reply ↓  Report •

#1
December 31, 2019 at 09:03:11
✔ Best Answer
First, a posting tip:

When posting in a help forum, it is customary to actually ask for help, as opposed to simply telling us what you want. I assume that if you were to walk into a co-worker's office with the same "want" you would say something like "Hey, can you help me out? I want to..." You might even end the request with a "Thank You". It should be no different in an "anonymous" help forum. We're all volunteers here, so it's nice to feel appreciated.


That said...

There is no need for VBA.

1 - Select the single cell with all the email addresses
2 - On the Data ribbon, choose Text-To-Columns
3 - Make sure "Delimited" is checked and click Next
4 - Check the Semicolon choice
5 - Click Finish

Assuming that there is no data next to your single cell, the email addresses will be split into separate cells at each semicolon. If you have data in other columns, just copy the single cell to a "safe" place and try the above process again.

6 - Now that each address is in its own cell, Select it all and Copy it.
7 - Choose an empty cell, Right-Click and choose the Transpose option. (the symbol with the arrows at right angles to each other)

The Columns will be pasted into Rows.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •
Related Solutions


Ask Question