Clean up a string
 

I have a long string that includes paragraph marks from Word, which I guess
are carriage returns. Does someone have a function I can use to strip these
out of my string?

TIA

Clean up a string
 

Replace(sStr,chr(10),"")

replace chr(10) with whatever character(s) you are trying to remove.

However, in my test, chr(10) is the correct character for your situation.
--
Regards,
Tom Ogilvy

"quartz" wrote in message
...
I have a long string that includes paragraph marks from Word, which I
guess
are carriage returns. Does someone have a function I can use to strip
these
out of my string?

TIA

Clean up a string
 

Another way:

clnStr = Application.WorksheetFunction.Clean(dirtyStr)

Sharad

"Tom Ogilvy" wrote in message
...
Replace(sStr,chr(10),"")

replace chr(10) with whatever character(s) you are trying to remove.

However, in my test, chr(10) is the correct character for your situation.
--
Regards,
Tom Ogilvy

"quartz" wrote in message
...
I have a long string that includes paragraph marks from Word, which I
guess
are carriage returns. Does someone have a function I can use to strip
these
out of my string?

TIA