If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Generally, when you write a Find/Replace statement in VBA, it is difficult to replace '?' (Question Mark) and '*' (Asterisk) Symbols/Characters with anything else. It ends up replacing all the characters. The reason for this is that '?' and '*' are wild card characters. '?' stands for 1 character and '*' stands for n characters (where n is any positive integer).

The way to do this is to precede the character '?' or '*' with a tilde '~'. Here's a sample code (if you want to replace '?' or '*' with a blank):