Select your cells, then display the Replace dialog, With the cursor in the
Find What box, hold down the ALT key and type 0010 on the numeric keypad
(not the numbers above the letters). Nothing will display, but the character
will be there. Then enter something in the Replace With box.




"ciruliz" wrote in message
...
Hi,
I must replace all new line characters in cell contents by something
(perhaps - space)
before converting to CSV, because otherwise CSV becomes unreadable for
other software.

I know, in Ms Word it is possible to replace ^p (which stands for new
line) with something

It does`nt work in Excel.

Any other options how to do that ?

Thanks!
Andis