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

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

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