wrapped text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cut and Paste Text with CRLF into Single Cell 1
Printing truncates cell contents 6
Transforming data in column into a linear text string 2
Text box behavior? 2
Expanding Capabilities of Wrap Text in a cell 1
RegEx - allowing for line-breaks 5
All Text Does Not Appear in Some Cells 2
finding where text wraps in a textbox 4

Back
Top