Line breaks in Excel?
 

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.

Line breaks in Excel?
 

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


"sawyet5" wrote:

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.

Line breaks in Excel?
 

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

"sawyet5" wrote:

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.

Line breaks in Excel?
 

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



"sawyet5" wrote in message
...
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.