wrapped text

H

Huge

How does one programmatically support Alt+Enter in a text file so as to automatically display multiline text in a cell when opening the file in excel. I have tried CR and LF as well as CRLF unsuccessfully. Thanks
 
H

Huge

Just realised that I can use comma's etc for text in same cell. Then use Replace All to remove comma's with Alt 010. This works fine except that I get multiple carriage returns - in fact if I have four lines I get 4 carriage returns between each of the lines.

Any ideas on how to prevent the multiple carraige returns?
Thanks again
 
D

Dave Peterson

If you started with 4 words separated by 3 commas, didn't you end up with 4
lines and 3 alt-enters?

If your data looked like: "test line,,,"
I could see why you have multiple consecutive alt-enters.

Couldn't you just edit replace two alt-enters with just one alt-enter (and
repeat till there aren't any more repeated alt-enters).
 
Top