Deleting the * character itself using VBA

[staggers47]

I've imported a fairly large Lexicon from Word into Excel.

I've now discovered that a lot of the words end with a star. This was obviously significant to the creator, but is havoc for me. Apart from anything else, a word being looked for that has a star on the end of it will never be found.

So, how do I remove the * wherever it is in the worksheet, given that it's a wildcard character?

Help much appreciated.

[jindon]

Use caret in replace word

~*

[staggers47]

Hi,

You said caret but you put a tilde. I tried them both but neither of them worked.

Here's the code:

Please Login or Register  to view this content.

I am doing several selection.replace, one after the other, on the same data to the same pattern, but this is the only one that doesn't work. What am I doing wrong?

[jindon]

It's a tilda....

Please Login or Register  to view this content.

Should do it

[staggers47]

Hi,

That worked fine for the single column, but I can't make it work when searching the multi-column range as above. So for now I'm just cheating and running it over each column one by one!

This will do for now, but if you find what's wrong I'd be glad to know.

[jindon]

It should...

Please Login or Register  to view this content.