MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.