Microsoft’s Excel has two functions called LOWER() & UPPER(). These functions simply changes the whole case of the string to either Lower Case or Upper Case.
Understanding the way Excel uses LOWER() & UPPER()
This formula requires 1 input; STRING.
The formula is as follows:
If I had the string “Ian Blott, Web Developer, Sydney Australia” in cell A1 and I wanted the string to be in all lower case
This would return the value “ian blott, web developer, sydney australia”
If I wanted the string to be in all upper case
This would return the value “IAN BLOTT, WEB DEVELOPER, SYDNEY AUSTRALIA”