LinkBack URL
About LinkBacks
Hi Guys,
I am facing problem with the special characters in excel files, we dont want any special characters in our data files, right now i am doing it by manual replace function.
I need a VBA code for replacing special characters.
~Ran
Hi Guys,
I am facing problem with the special characters in excel files, we dont want any special characters in our data files, right now i am doing it by manual replace function.
I need a VBA code for replacing special characters.
~Ran
How are you doing it manually?
Hey, thanks for your reply.
Currently i am doing it by using Find & Replace function (Control + H) for each character.
Please help me with the VBA code so that my work goes easy..
~Ran
I was hoping your answer would give some indication of what special characters you were trying to remove.
Hi,
These are the special characters i need to replace to the normal one.
à,á,å,â,ã,ä,ç,è,é,ê,ë,ì,í,î,ï,ñ,ò,ó,ô,õ,ö,š,ù,ú,û,ü,ý,ÿ,ž,ß
~Ran
Hi,
These are the special characters i need to replace to the normal one.
à,á,å,â,ã,ä,ç,è,é,ê,ë,ì,í,î,ï,ñ,ò,ó,ô,õ,ö,š,ù,ú,û,ü,ý,ÿ,ž,ß
~Ran
There are a few other characters you might also not want to have in a file name like forward and back slashes.
I think the following code will do it for you. It can be used as a formula on the spreadsheet or in code.
Please Login or Register to view this content.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
I just re-read the requirement. You are not going for a file name. So some of the characters I am eliminating, you might want to keep. In that case, change the Arrays to:
And remove the followingPlease Login or Register to view this content.
Please Login or Register to view this content.
Thank you so much dflak for you help...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks