Excel 2013 Tutorial - How to Clean Strange Characters from Text
In this tutorial you will learn:
How to clean unprintable characters from a text.
When importing from external databases strange characters may come in you data. In order for fixing this problem the CLEANING function comes in help.
In order to also remove unnecessary spaces you can use the TRIM function together with the clean function.