Excel CLEAN Function: Eliminate Non Printable Characters
Command: CLEAN
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.
Example 1:
=clean(A1)
If cell A1 = ” 52899 ”, then it will return JUST the numbers, not the spaces