Remove Carriage returns

  • Thread starter Thread starter LJG
  • Start date Start date
L

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
 
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).
 
Back
Top