There is an interesting function in Excel worksheets. I know that you are most likely thinking – well most of them are pretty interesting, but this particular function is interesting in that it makes sure that your text is clean. What do I mean by clean? Well it means that Excel makes sure that your text contains only printable characters and will remove certain non-printable characters and control codes that may be contained in the text in your worksheet.
The function syntax is pretty simple as you can see below:
You simply include the text or a reference to a cell that contains text.
Hmmm… you might ask why would you even clean your text?
Well if you import information from the Internet or some server other than your own, the non-printable characters could come along with whatever you have copied, which can cause you problems when you are attempting to view or print the information.
It’s always good to be clean right?