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.
Comentarios