Excel Snippets: TRIM and CLEAN Functions

I might not post many Excel snippets, but I’m collecting them into a small series to make them easy to find. Data imported from other systems or copied from web pages frequently contains extra spaces or non-printable characters that cause problems with lookups, comparisons, and formulas. The TRIM and CLEAN functions are the first line...

Read original post Excel Snippets: TRIM and CLEAN Functions at azurecurve|Ramblings of an IT Professional