find and replace special characters

Which part is not working?

As far as I know, you will face problems with "*" and "?" characters. You have to add the "~" character to specifically search for them.

So in your array, change "*" and "?" to "~*" and "~?".

Not sure if there are any other problems in there.

Originally Posted by millz

Which part is not working?

As far as I know, you will face problems with "*" and "?" characters. You have to add the "~" character to specifically search for them.

So in your array, change "*" and "?" to "~*" and "~?".

Not sure if there are any other problems in there.

Thanks for responding. But there is a problem in the code that it doesnt find all the special characters in a particular column instead it just replaces only top 2 rows. also it deletes everything in one of the top rows. please suggest a code correction. The for loop for Replacing is not working. It just replaces only top two rows.

Was having a rather busy day yesterday, hence the slow response.

Also, I usually avoid naming my subs the same as some built-in function names, just in case any clashes happen.

Try this:

Please Login or Register  to view this content.