Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I add a carriage return into a cell in Excel?
I have tried the <ALT 0010 but I keep getting 'L' appearing instead of a
'hard carrige return' (which I understand will be invisible). Please help - it's driving me nuts! (I am using Excel 2003) |
#2
|
|||
|
|||
pm, try Alt+enter
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "pm" wrote in message ... I have tried the <ALT 0010 but I keep getting 'L' appearing instead of a 'hard carrige return' (which I understand will be invisible). Please help - it's driving me nuts! (I am using Excel 2003) |
#3
|
|||
|
|||
Use ALT+ENTER.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "pm" wrote in message ... I have tried the <ALT 0010 but I keep getting 'L' appearing instead of a 'hard carrige return' (which I understand will be invisible). Please help - it's driving me nuts! (I am using Excel 2003) |
#4
|
|||
|
|||
And in a formula:
=a1&char(10)&b1 pm wrote: I have tried the <ALT 0010 but I keep getting 'L' appearing instead of a 'hard carrige return' (which I understand will be invisible). Please help - it's driving me nuts! (I am using Excel 2003) -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to return the value of a cell based on a looked up true reference | Excel Worksheet Functions | |||
How to make a cell return the formatted value in a text string (i. | Excel Worksheet Functions | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
Carriage Return in Excel | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |