Hard return in wraptext cell?

[MP]

Is there a way to place a hard return(carriage return) in a cell with wrap
text format
so as to align text in the way user wants rather than what excel places?
Thanks
Mark

 

[Tyro]

Sure. Where you want a new line just press Alt+Enter. To remove that just
place the cursor at the end of the line before the new line and press Delete

Tyro

 

[Chip Pearson]

In a formula, you can use CHAR(10) to insert a line break. E.g.,

="abc"&CHAR(10)&"cde"

If you are entering text directly into the cell, use ALT ENTER to insert a
line break.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[MP]

Thank you both,

In a formula, you can use CHAR(10) to insert a line break. E.g.,

="abc"&CHAR(10)&"cde"

If you are entering text directly into the cell, use ALT ENTER to insert a
line break.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)