One option is to substitute the carriage return for other symbol. You can
create an additional column with a formula like:
=SUBSTITUTE(A1,CHAR(10),"|")
And perform the text to columns on the results, using the | as separator.

Hope this helps,
Miguel.

"CraigR53" wrote:

I have complete addresses including hard carriage returnss in my original
data. (That is, I have three lines in each cell.) How do I make the CR's a
delimiter for text-to-column conversion?