Wrapped Cell Question
Posted by Keith Hall on December 19, 2001 12:07 PM
Is there a way that in a cell which is formatted as "Wrapped" to force a new line within the cell? For example,
First Line [Cell ends here]
Second Line
I know that I can simply put a bunch of spaces at the end of the first line to force it to a second line, but is there a better way? Thanks....
Posted by Juan Pablo G. on December 19, 2001 12:13 PM
If you're writing the text, then Alt Enter should insert a new line. If you want to do this with a formula then use this:
="First line"&CHAR(10)&"Second Line"
Juan Pablo G.
Posted by Mark W. on December 19, 2001 1:21 PM
Or, type...
First Line [Alt+Enter]
Second Line [Enter]
Posted by Jack in UK on December 19, 2001 4:24 PM
Juan Pablo G.
Juan Pablo G.
Cheers mate i posted simular few days ago and had nil responce, though not possible, i knew square would do it, but struggled.Cheers mate, im very happy with that, i will huse this every day, OK ill UDF so faster, but hey cheers.
