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.