Uppercase in Excel

So, you have a couple of hundred customer names and need to make them uppercase?

There’s a button for that!

Ok, so its not really a button but there is a formula for that and its simple to use.

In a column next to your list type =Upper(cell with your text). Then press Enter.

The result should be the name or word in Upper case. Copy that formula down and Voila!

Of course there is a =Lower() and even =Proper() if you want to take it that far.