Hi Friends
I have the below code but it does not find the special character and replace it.
can anyone help please.
Thanks in advance.Please Login or Register to view this content.
Hi Friends
I have the below code but it does not find the special character and replace it.
can anyone help please.
Thanks in advance.Please Login or Register to view this content.
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.
Last edited by irfanparbatani; 09-15-2015 at 12:22 AM.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks