Skip to main content
Microsoft Office 365

Office 365: Using the PROPER/UPPER/LOWER Functions in Excel

By July 30, 2019No Comments

If you have ever needed to normalize the cases of words in Excel, this tip is for you! Excel actually has functions for this: PROPER, UPPER, and LOWER.

UPPER and LOWER are pretty self-explanatory–Upper makes all characters uppercase:

Lower makes all characters lowercase:

PROPER actually capitalizes the first character in each word specified:

 

Leave a Reply

Skip to content