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)

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)

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)

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