How to clean out non-printable characters from an Excel file by using Power Query
All together there are 95 printable characters in ASCII code: from "space" (char 32) to "tilde" (char 126).
When using text in our spreadsheets whose source is from the internet or from non-Windows applications, many times this will contain "non-printable Windows characters that might cause us many problems in our spreadsheets.
The easiest and fastest way to clean out all these non-printable characters is by using Power Query.