How do I add a carriage return into a cell in Excel?

G

Guest

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)
 
P

Paul B

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
 
D

Dave Peterson

And in a formula:

=a1&char(10)&b1


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)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unicode text and carriage returns 4
Getting rid of carriage return in cell 4
how do i format carriage returns for each cell in excel? 1
Carriage Return in Excel 3
carriage returns 2
copying/pasting accurately from a Word table (carriage returns) 1
Separating carriage return data into separate cells 2
Show or Hide control characters in a cell (using Excel 2007)... 0

Top