Urgent: Splitting e-mail addresses from one cell

[adobeee]

Hi all,

I am trying to separate multiple e-mail addresses from one cell into multiple cells. Currently, the e-mail addresses in each cell are separated by lines (alt+enter). I searched through the forum and couldn't find any solutions. Any help would be appreciated!

Here's what's inside the cell in column A:

A1
1@abc.com
2@abc.com
3@abc.com

A2

4@abc.com
5@abc.com

Here's how I want it to look in the column B:

B1
1@abc.com

B2
2@abc.com

B3
3@abc.com

B4
4@abc.com

and so on...

May anyone help with this please? Thanks in advance!

[alansidman]

I can give you a solution to put them across so that they are in B1,D1,E1 You maybe able to transpose them afterwards.

Anyway.

Highlight the A Column. Click on Text to Columns on the Ribbon. Select Delimited. Select Other. Holding down the ALT key type 0010 in your keypad. Nothing will appear. Click on Enter and Finish.

Alan

[adobeee]

yay thanks so much!! +1 rep for you

[alansidman]

Thanks much.