Site icon ExcelNotes

How to Use UPPER Function

The UPPER function is to convert all letters in lower case in a text string to upper cases, and keep other characters as they are. For example, "Upper Function 1" to "UPPER FUNCTION 1".

Formula:

= UPPER(text)

Explanations:

–Text is required, the text string that you need to covert lower cases to upper cases.

Cautions:

– All the characters in the text string that are not letters will not be changed

Example: Change all letters "How to Use UPPER Function" to upper cases?

=UPPER(A2)

The result returns "HOW TO USE UPPER FUNCTION", all letters are now in upper cases.

Download: UPPER Function

Exit mobile version