Line breaks in Excel?

[Guest]

Can anyone tell me a way to insert line breaks within a single cell of an
Excel worksheet? I know how to wrap the text, but this doesn't allow you to
break the line of text in particular places.

 

[Guest]

When typing a cell entry:
Hold down the [Alt] key when you press [Enter].

That will insert a 'hard carriage return' in the cell

Does that help?

••••••••••
Regards,
Ron

 

[Guest]

Use Alt+Enter to break the text where you want to

 

[Chip Pearson]

If you are typing in the cell, use ALT+ENTER to enter a line
break. In a formula, use CHAR(10), e.g.,

="Line One"&CHAR(10)&"Line Two"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com