I am looking for a solution. i have a cell containing special characters "???????*" . How to use subsitute column to replace it with blank cell. i need this as vlookup don't work with special characters.
I used this formula =SUBSTITUTE(G3,"?",""). But, this is just replacing only "?". I also wanted to replace "*" using the same formula.
Please help in resolving the issue. I am beginner and learning excel