Remove linefeeds from calc cells

[Cakiwi]

I am importing csv files which have line feeds at the end of some text fields. I can remove them manually by positioning the cursor at the end of the field and hitting the delete key. Is there a way to do a mass substitution? I have tried many different find and replace options, include regex $ and regex .$ to no avail.

Any help greatly appreciated

[Craig22]

Hello,

to find linefeeds use RegEx:
\n

Replace:

$1

If there is a linefeed between two words You have to insert a Space before:

$1

Regards

Craig

[Cakiwi]

Thanks Craig, that worked. I was sure I had tried that but apparently not. Thanks again.