StrReplace newline

Hi,

I am trying to replace a comma with newline with StrReplace, I have tried:-

StrReplace(myvariable,",","\r\n")
and
StrReplace(myvariable,",","\n")

These just change to \r\n or \n. Also tried without quotes and tried chr$(13), none work, can this be done with StrReplace?

TIA

Try this one:
StrReplace(myvariable,",",crlf)

Best regards.

klaus said:

Try this one:
StrReplace(myvariable,",",crlf)

Best regards.

Click to expand...

Perfect, thanks so much.