Converting UNIX end of line 1

[SteveCulshaw]

Can anyone explain how I convert the UNIX end of line character? - I think it's chr(10)
I need to change it to a <space>
I've tried
formula = Replace ({BCCASE.ADDRESS}, chr(10), &quot; &quot; ) Cheers,
Steve C.

 

[Naith]

Chr(10) is backspace. Space is Chr(40).

 

[Naith]

Try Replace ({BCCASE.ADDRESS}, chr(13), &quot; &quot; )

 

[SteveCulshaw]

Thanks for that, the replace of chr(13) with &quot; &quot; worked a treat Cheers,
Steve C.