MS Excel: Remove question mark inside box character

I had an excel file where one column had junk characters like question mark inside a box as in below screenshot. I needed to remove the junk. I tried Find-Repace option, trim, Substitute etc. None of these formulas worked. Then I found the function =CLEAN() to remove junks. It worked fine.


No comments:

Post a Comment