Excel CLEAN Function: Eliminate Non Printable Characters
CLEAN function is used to eliminate any non-printable characters. Similar to TRIM.
Use: if lookups aren’t working properly, try to use CLEAN function on referencing cells.
If cell A1 = ” 52899 ”, then it will return JUST the numbers, not the spaces