phil

Alt + 0010 in the "replace with" box will give you a CR in the cell.

Must be typed in using the NumPad at right, not the number keys above qwerty.

You don't want Alt 0160.......that is non-breaking space.

Alternative to Alt + 0010 is CTRL j


Gord Dibben MS Excel MVP


On Thu, 10 May 2007 12:23:05 -0700, philr
wrote:

I have a similar problem but I need to put the hard paragraph back into the
text which was copied over from Word into Excel. In the Replace with box I've
tried alt 0010, alt 0182, alt 0160 (all on the number pad) but each time I
get an error saying "formula too long." The alt 0182 shows the hard paragraph
symbol but I get the message. The alt 0160 shows a period.