Excel Change case functions- UPPER & LOWER

Excel Version in which UPPER & LOWER functions can work:

Excel Change case functions will work in Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Mobile Excel for Android phones.

About Excel Change case functions- UPPER & LOWER:

UPPER function in excel converts all texts to Uppercase. If the characters are other than letters , they are unaffected by using this function.

LOWER function in excel converts all texts to lowercase. If the characters are other than letters , they are unaffected by using this function.

These are built-in function in Excel that is categorized as a Text Function

Syntax for UPPER & LOWER:

=LOWER(text)
=UPPER(text)
Parameters:
Text: The word which you want to convert from.

Using UPPER & LOWER function:

If we want to convert above words to Upper case, assume B2, B3 and B4 are the cell reference respectively.

Words Formula Result
REVIEW  =UPPER(B2) REVIEW
MAILings  =UPPER(B3) MAILINGS
InSeRt  =UPPER(B4) INSERT

UPPER FUNCTION

Like UPPER function, If we want to convert following words to Lower case, assume B2, B3 and B4 are the cell reference respectively.

Words Formula Result
REVIEW  =LOWER(B2) review
MAILings  =LOWER(B3) mailings
InSeRt  =LOWER(B4) insert

LOWER FUNCTION

These functions can be clubbed with any other functions in excel.

One Comment

Add a Comment

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