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:


If cell A1 = ”  52899  ”, then it will return JUST the numbers, not the spaces