MS Excel: LOWER() & UPPER() Functions

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:

LOWER(STRING)
[/cc]

OR

UPPER(STRING)
[/cc]

Using LOWER()

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

LOWER(A1)
[/cc]

This would return the value “ian blott, web developer, sydney australia”

Using UPPER()

If I wanted the string to be in all upper case

UPPER(A1)
[/cc]

This would return the value “IAN BLOTT, WEB DEVELOPER, SYDNEY AUSTRALIA”


	

Leave a Reply