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.

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.

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.

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" <[email protected]> wrote in message
news:[email protected]...
> 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.