Thanks for the code DataMizer. I almost had it, but your function is much better than the code I was using.

I still have a problem with the string I am searching. The string contains both VbCrVbCr(enter key pressed twice) and VbCr(enter key pressed once). I can't get the function to work using VbCrVbCr. The best I can do is use chr(13) as the Target in your function and then it returns "sometext</p></p>sometext</p>sometext" whereas
what I want to return is "sometext<p>sometext</p>sometext".

It is not recognizing the VbCrVbCr correctly. I have looked at the Hex code and it is "0D0A0D0A"
How can I correct this?

The second question I have is: I tried to run your function twice, the first time looking for chr(13) and the second time looking for "</p></p>". The second time the function ran, it truncated the first letter after the "</p></p>". I can't figure that out.


Also thanks to you dglienna. I agree with you about VB5. Thanks to you suggesting on one of my previous posts, I have decide to convert over to VS2010 later this year(I hope), but for the present time I need to use VB5 to solve the immediate problem. Time is critical here.

Thanks for all of you helping with this!!!!!!!!!!!!