There is a fairly efficient method to clean up the weird little characters that you sometimes bring along when you have copied or imported data into your spreadsheets.
There is a little heard of function in MS Excel called, appropriately enough, the Clean function and that is what you use to clean up those weird little characters. Go figure!
There are a number of functions that allow you to remove printable characters such as spaces, in MS Excel. But if your data contains non-printable characters, you might be in a pickle.
Fear not, follow the steps below to clean up your data.
- Select A1:A6.
- Enter the following formula:
- =CLEAN (A2)
- Press CTRL + Enter.
MS Excel will display the contents of the cells without the non-printing characters. You can now copy the results to another part of your Workbook using the Paste Special option to copy the values without the formulas.
Pretty cool isn’t it?