Using Text to Columns without Delimiters

[GMC The Macro Man]

Hi team
I am trying to split 4 names that have been typed into ONE cell by using the ALT+ENTER (to make it look nice in the cell) however this has left NO delimiters for me to use so I can separate them into columns.
I'm trying to use both the Text to Columns and TextSplit but both want delimiters. Is there any other formula that sees a RETURN in a cell? I have over 200 entries that I want to split so any help would be appreciated
The image below shows you the preview where there is NO SPACE or anything between the names

 

[Fluff]

With Text To Columns select other & enter Ctrl J, or with TextSplit use CHAR(10)

 

[GMC The Macro Man]

With Text To Columns select other & enter Ctrl J, or with TextSplit use CHAR(10)

Hey Fluff, I need to meet up with you one day and get you a beer . Thank you sooooo much for this

 

[Fluff]

You're welcome & thanks for the feedback.