I'm by no means an Excel guru, more of a scrappy Excel user. All I did is
copied the cells with hard returns in them into "Notepad" and then copied
them back into Excel, then used the text to column feature to get rid of the
"quote" marks that Notepad added. No complex code, and no purchase of Ultra
Edit, and you can do it in 2 minutes. Sometimes just messing around gets you
an answer

"tkwriter" wrote:

Did you ever get a satisfactory answer to this? I have the same question: I
want to import a txt file to an excel spreadsheet. What character can I use
to specify that the delimiter is a line break (hard return)? Is it even
possible to do this?


"Gordo T" wrote:

I need to import a text file of data where the delimiter between fields is a
carriage return.
--
Gordo T