UPPER

Definition: The UPPER function in Excel is used to convert text to uppercase.

Syntax: ==UPPER(text).

Situation: This formula is appropriate in situations where you need to convert text to uppercase.

Example: If you have a cell that contains the text string “this is a text string”, you would use the formula =UPPER(“this is a text string”). This would return the text string “THIS IS A TEXT STRING”.