Data can be messy, especially when you’re pulling it from multiple sources. Things are often a mix of uppercase, lowercase or proper case (where the first letter is uppercase and all other letters are lowercase). How can you easily make the casing consistent? It’s actually very easy!
In a hands-on tutorial, I’ll show you how to easily convert text to all UPPERCASE, lowercase and Proper Case.
00:00 – Overviewing the original text that has a mix of uppercase and lowercase
00:28 – Changing all text to uppercase in Excel
01:07 – Changing all text to lowercase in Excel
01:23 – Changing all text to Proper Case (first letter is uppercase, all other letters are lowercase) in Excel