Firstly, make a copy of your worksheet to practice on.
Then, use the Substitute function.
=SUBSTITUTE(F5,"*",",") - except instead of the asterisk, hit ALT-Enter.
(this forces a line break)
The formula results will have the char(10) replaced with a comma.
If there are multiple instances of the line breaks in your text, leave the last argument in the SUBSTITUTE function out,
That way, all instances will be replaced.
Next, do Copy>Paste Special>Values.
Then go to Data>Text to Columns. Click the Commas button, Finish.