Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |