It may be just \r. You can use in VBA VBCR, VBLF, VBCRLF instead of \r.
If none of thes work I usually dump the stinrg into the worksheet.
RowCount = 1
for i = 1 to len(MyStr)
Range("A" & rowcount) = mid(MyStr,1,1)
Range("B" & RowCount) = asc(mid(MyStr,1,1))
RowCount = RowCount + 1
next i
this will give you the Ascii values of each of the characters in the
string. Then you can use replace and instead of specifying the
character use the number with Chr(x)
like this
replace(MyStr,chr(10),chr(13))
It it turns out to be just \r then you may want to replace with Chr(13)
& chr(10). windows uses both the \CR and \LF.
--
joel
------------------------------------------------------------------------
joel's Profile:
http://www.thecodecage.com/forumz/member.php?userid=229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=147157