Trying to create a function that removes the carriage return from a string .

[jimjam]

Any idea why this does not work?

Public Function fNixCr(sIn As String)
sIn = Replace(sIn, vbCrLr, "")
sIn = Replace(sIn, vbCr, "")
fNixCr = sIn



End Function



Immediate window:
?fNixCr("Hello" & vbCrLf & "multiverse")
Hello
multiverse


I would have expected this to print:
Hellomultiverse

Flummoxed.

[Rod]

sIn = Replace(sIn, vbCrLr, "")

Try replacing vbCrLr with vbCrLf

[orange]

You spelled vbCrLf wrong.

[jimjam]

<cringe> thanks guys. lol.