If you used alt-enter for that new line character, you can

Select the range to fix
edit|replace
what: ctrl-j
with: (spacebar) (or whatever you want)
replace all



ciruliz wrote:

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

--

Dave Peterson