Parse field for carriage returns/linefeeds 1

[mulligh]

I have a field that I want to be able to put some type of &quot;marker&quot; in to indicate a carriage return or linefeed. I was thinking of something like <cr>.

So a sample text string might be:

&quot;I want a carriage return <cr> here and also <cr> here&quot;

How can I parse the string to convert the <cr> into a carriage return/line feed in VBA? I know about the vbCrLf command, but am not sure how to put it all together.

Thanks for your help.

 

[sfvb]

Here's an example:

MyStr = &quot;I want a carriage return <cr> here and also <cr> here&quot;
MyStr = Replace(MyStr, &quot;<cr>&quot;, vbCrLf)

 

[mulligh]

Thanks, this worked great.