Hard CR in a Cell
 

I am unable to locate information on how to put a Carriage Return (CR) in a
cell.
I am attempting to type a partial line, then place a CR to start a new line
within the same cell. I have been unable to find any information on
resolving this issue. The only way so far to solve this issue is to create
the data in word, cut/paste in back into the cell. This is a round-about way
to do things. Any ideas on how to resolve this issue??
--
Brian

Hard CR in a Cell
 

Hi Brian,
Actually you use LF (Line Feed) in Excel.
In a worksheet function it is CHAR(10) in a concatenation
and in VBA it is CHR(10) or xlLF

="line 1" & Char(10) & "line 2" & " more for line 2"

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Brian" wrote in message ...
I am unable to locate information on how to put a Carriage Return (CR) in a
cell.
I am attempting to type a partial line, then place a CR to start a new line
within the same cell. I have been unable to find any information on
resolving this issue. The only way so far to solve this issue is to create
the data in word, cut/paste in back into the cell. This is a round-about way
to do things. Any ideas on how to resolve this issue??
--
Brian

Hard CR in a Cell
 

Brian,
If you're physically typing in a cell, you can use Alt+Enter and it will
give you a new line instead of moving you to the next row down.

Alicia

"Brian" wrote:

I am unable to locate information on how to put a Carriage Return (CR) in a
cell.
I am attempting to type a partial line, then place a CR to start a new line
within the same cell. I have been unable to find any information on
resolving this issue. The only way so far to solve this issue is to create
the data in word, cut/paste in back into the cell. This is a round-about way
to do things. Any ideas on how to resolve this issue??
--
Brian