Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm preparing an Excel report in which some cells must contain
multiple lines of text. Because of the way Excel handles line feeds, I'm struggling to format the report properly. From what I can figure, Excel offers two options: 1) With Wrap Text on, it will break the text at line feeds and whenever the next word will not fit in the cell. 2) With Wrap Text off, it will never break the text; it will either ignore line feeds or display them as squares. What I want is a third option: 3) Break the text at line feeds only (like Notepad does when Word Wrap is off). Is there any way to make Excel behave that way? -TC |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Worksheet Functions | |||
Replace Line Feed | Excel Discussion (Misc queries) | |||
How to do a line feed in a Text Box | Excel Programming | |||
Line Feed | Excel Programming | |||
how does excel store new line and line feed characters? | Excel Programming |