How to change lowercase to uppercase in excel without formula

If you have worked in Excel then you know there are times when you want to make text UPPER or lowercase. While other Office products like Word or Outlook have a shortcut for this (it’s Shift+F3 by the way), Excel does not have a quick way to convert your text.

How to change first letter to uppercase in excel

Instead, Excel provides 3 functions to convert text to “UPPER”, “lower” or “Proper” cases.

How to use UPPER, LOWER, and PROPER functions

All three functions have only one argument: text. All you have to do is provide the text you want to convert and the function will do the rest.

Since you will rarely have all your text in one cell you can use concatenation for more flexibility.

Cells C3 to C5 contain the following formulas:
C3:
C4: 
C5: 

To better understand the way each of these functions works, I have prepared another example that is closer to a real-life task.

In the Excel workbook, we have the ID, First name, and Last name of the employees of Company, Inc.

However, the First name is properly capitalized (“Emma”), but the Last name has all letters capitalized (“SMITH”). If we want to get the First and Last name in

how to change case in excel without formula

how to uppercase in excel shortcut key