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:
