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