I am however a little confused. I am under the impression that in you example:
F5 is the Range, "*" is something to do with the Alt-Enter and "," is replacing something with a comma.
Is this correct?
I am however, still confused with how this removes the Alt-Enter and displays the data onto different rows.
If you could give me a little more direction, I would be grateful.
Hi, Kieron -- here's what I did, based on Hugh's answer above:
In the top cell of the column next to the column that I wanted to separate (call it "B2"), I entered the following: =SUBSTITUTE(A2,CHAR(10),*); [that's not really an asterisk: it's the "alt-0149" dot] Then I simply copied that formula all the way down to the bottom row. That gave me a column in which all the "hard returns" from A2 were now represented by the Alt-0149 dot. Then I used Text to Columns with the dot as my separator (this keeps things from getting screwy if you actually have commas in your cells)