Excel Snippets: UPPER, LOWER and PROPER Functions

I might not post many Excel snippets, but I’m collecting them into a small series to make them easy to find. When combining data from different sources, text case is often inconsistent. A customer name entered as “john smith” in one system may appear as “JOHN SMITH” in another. The UPPER, LOWER, and PROPER functions...

Read original post Excel Snippets: UPPER, LOWER and PROPER Functions at azurecurve|Ramblings of an IT Professional