Hard return in wraptext cell?

  • Thread starter Thread starter MP
  • Start date Start date
M

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
 
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
 
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)
 
Thank you both,


Chip Pearson said:
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)
Click to expand...
 
Back
Top