The UPPER function in Excel converts all letters in a text string to uppercase. This is particularly useful when you need to standardize text data, such as names or addresses, to ensure consistency.

Syntax:

UPPER(text)

• text: The text string you want to convert to uppercase. This can be a direct text entry, a cell reference, or a formula that returns text.

Example:
If cell A1 contains the text “hello world”, the formula =UPPER(A1) will return “HELLO WORLD”.

Steps to Use UPPER Function:

1. Select the cell where you want the uppercase text to appear.
2. Type =UPPER( and then select the cell containing the text you want to convert, or type the text directly within the formula.
3. Close the formula with a closing parenthesis ) and press Enter.
4. The result will display the text in uppercase.

Tips:

• UPPER does not affect numbers, symbols, or spaces.
• If you need to convert text to lowercase, use the LOWER function.
• To capitalize only the first letter of each word, use the PROPER function.