Creating a CRLF

[Bruce A. Julseth]

When I enter a string of text for a cell, how do I enter a CRLF? For
example, I enter:

This is my formated paragraph.

and I want it appear in a cell (wrap text is turned on) as:

This is
my
formated paragraph.

I can enter is NotePad and cut N paste but there must be a way to do it
directly in Excel.

Thanks

Bruce

 

[Peo Sjoblom]

Alt + enter

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Bruce A. Julseth]

Thank you...

I tried to use Excel Help to find this but FAILED. Is it in help somewhere?

Bruce

 

[Bernard Liengme]

The keyword here is 'wrap'
In Excelese, your test is wrapped
best wishes

 

[David McRitchie]

Alt + Enter turns on Cell Wrap for you

If you were concatenating cells with a worksheet formula
you would use CHAR(10) in the concatenation, and you
should have to turn on cell wrap yourself.
Format, cells, alignment, cell wrap

=A1 & CHAR(10) & B1

In VBA you would use CHR(10) instead of CHAR(10) in
your concatenation.

More information on strings in
http://www.mvps.org/dmcritchie/excel/strings.htm

and, of course, this is all in HELP. Now that you know the answers
try finding it again.

 

[JJ Mintz]

This is called making a line break. To start a new line of text at a
specific point: click where you want to break the line, and then ...

On a Mac: press CONTROL+OPTION+RETURN.

On a PC: press Alt+RETURN.