Megan Hagedorn No 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

Your email address will not be published. Required fields are marked *