Hi all,

I am having trouble trying to find a Char in a fixed position and then replacing it if it exists.

I was using something like this:
ElseIf Right(DSCode, 1) = "." Then
DSCstr = Replace("DSCode", ".", "_", , 1, vbTextCompare)

But It does not work (no laughing pls, I am still in the novice learning stage)

Can any one point me in the right direction pls.

Any help / advice would be great.

Thanks in advance,
Rocks.