Split data in a row

[ExcelGeek25]

Hello, I want to split the text/ emails inside an Excel row. If there was a delimiter, I'd have used Text to Columns but there is none here. The sample data looks like this:

All within 1 row:

abc@yahoo.com
abc@google.com
abc@outlook.com

I want to separate the above and take the 3 email addresses into 3 different cells next to each other or 1 below the other.

 

[Debaser]

If those are all in one cell, then there probably is a linefeed delimiter, so you can use Text to Columns, and use the Other option, then click in the box for the character and type Ctrl+j

 

[ExcelGeek25]

If those are all in one cell, then there probably is a linefeed delimiter, so you can use Text to Columns, and use the Other option, then click in the box for the character and type Ctrl+j

Thank you, Sir! You have saved hours of my life...I really did not know how to do this and I had considered myself decently good at Excel :-(