elliminate commas, semicolons, colons, etc. from a string

If I have a string that is kept strictly within VBA that goes something like this:

"This, here: is; my string"

what is the most efficient way to eliminate commas, semicolons, and colons and convert it to "This here is my string"?

I just need VBA, not a formula.

Thanks

Try

Please Login or Register  to view this content.