While uploading an excel file, special characters like . / - etc. are not allowed / gives error.
So these special characters need to be replaced with a blank space (as seen in attached sample sheet)
Possible to do this with CONCATENATE or any OTHER FORMULA ?
Please provide a list of ALL special characters you want replaced. thx
"The formula would look like this
=SUBSTITUTE(SUBSTITUTE(C2,"/"," "),"-"," ")
I did this with a VBA formula. The formula is GoodFileName and it takes two arguments: =GoodFileName(StringName, What to replace with).
For example: =GoodFileName("08/01/2023", " ") = 08 01 2023 while = GoodFileName ("08/01/2023","_") = 08_01_2023.
You can also accomplish the same thing using multiply nested SUBSITUTE commands using the CHAR() functions for unprintable characters.
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.
Thanks for your quick response.
Just 2 special characters viz. / -
Thanks but I do not know VBA
Post #3???
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks a lot for the formula. It solved the problem. Many thanks once again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks