Using the Excel Function SUBSTITUTE all the special characters to "_".
Please do not use nested substitute or macro.
EX
A1:A@S#DF$23
Result
B1:A_S_DF_23
Using the Excel Function SUBSTITUTE all the special characters to "_".
Please do not use nested substitute or macro.
EX
A1:A@S#DF$23
Result
B1:A_S_DF_23
ctrl+F find and replace.
If someone helped give them rep using the star button.
If you have received a satisfactory solution please mark the thread solved. If not Fotis will come for you at night :P
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks