Remove Carriage returns

[LJG]

I am looking for a method to strip out any line breaks or carriage returns.

I have imported some data and one of the fields has line breaks & carriage
returns. I need to convert this to a CSV file with no returns and line
breaks etc.

Thanks
Les

 

[Ken Snell [MVP]]

Check out the Replace function; it allows the replacement of a text string
with a different text string. This works for individual characters or a
string of characters. Line feed is Chr(10); carriage return is Chr(13).