VBA Replace() doesn't replace characters

Question

This is odd. In the code below the replace() does not replace the : character. Why? How do I fix this? Even if I switch ":" with chr(58) it doesn't work.

Dim dispName as String
dispName = "     110531 Re：Our file 027-10.doc"
dispName = Replace(dispName, ":", " ")
msgbox dispName

look at your :, it looks like that is not the same as the other one — Kᴀτᴢ
– Kᴀτᴢ, Commented Feb 24, 2015 at 15:05
So weird - VBA identifies both with chr() as 58. Thanks for the help. — user2104778
– user2104778, Commented Feb 25, 2015 at 7:16

Tushar · Accepted Answer · 2015-02-24 15:08:01Z

2

I copied your code as it is to notepad++ and found that used both ':' characters are different.

Change both to the same and run the code

answered Feb 24, 2015 at 15:08

Tushar

3,6759 gold badges31 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBA Replace() doesn't replace characters

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related