I have an excel sheet with multiple email addresses in each cell in one column. Some cells have no addresses, others have many, each cell is different. The email addresses are semicolon delimited, so it's easy to do Text to Columns to extract the individual email addresses into separate columns. However, I'd like to get all of the emails listed one by one in one column vs. spread out across multiple columns. Any help would be much appreciated.
Here's an example of the data for one column
cell 1: xxx@xx.com; xxy@xx.com; xxz@xx.com
cell 2: blank
cell 3: xxa@xx.com; xxb@xx.com
cell 4: xxc@xx.com; xxd@xx.com; xxe@xx.com; xxf@xx.com; xxg@xx.com
I'd like to end up with (all in one column):
xxx@xx.com
xxy@xx.com
xxz@xx.com
xxa@xx.com
xxb@xx.com
xxc@xx.com
xxd@xx.com
xxe@xx.com
xxf@xx.com
xxg@xx.com
Thanks!
-Scott
Here's an example of the data for one column
cell 1: xxx@xx.com; xxy@xx.com; xxz@xx.com
cell 2: blank
cell 3: xxa@xx.com; xxb@xx.com
cell 4: xxc@xx.com; xxd@xx.com; xxe@xx.com; xxf@xx.com; xxg@xx.com
I'd like to end up with (all in one column):
xxx@xx.com
xxy@xx.com
xxz@xx.com
xxa@xx.com
xxb@xx.com
xxc@xx.com
xxd@xx.com
xxe@xx.com
xxf@xx.com
xxg@xx.com
Thanks!
-Scott