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!