good, big thanks for ideas.
Actually I figured out other way :

simple VB macro:

Public Sub ConvertCells()

Dim Cell As Range
For Each Cell In Application.Selection
Cell = Replace(Cell, vbLf, " ")
Next Cell

End Sub


which works as expected :)

Best regards, Andis


"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