top of page

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.

Recent Posts

See All
Get it together.

Here is a quick way to join the contents of 2 cell and display the results in third cell. · Find an empty cell and type the “=” sign. ·...

 
 

Comentários


Não é mais possível comentar esta publicação. Contate o proprietário do site para mais informações.
  • X
  • Youtube
bottom of page