Excel Tutorial – UPPER

The UPPER function in Microsoft Excel is a function that converts all the characters in a cell to uppercase. This can be useful if you want to standardize the formatting of your data or if you want to perform case-insensitive comparisons.

To use the UPPER function, follow these steps:

1. Open your Excel workbook and navigate to the cell where you want to apply the UPPER function.
2. Type “=UPPER(” into the cell, followed by the cell reference or text that you want to convert to uppercase. For example, if you want to convert the text in cell A1 to uppercase, you would type “=UPPER(A1)”.
3. Press the “Enter” key to complete the formula. The cell will now display the text in uppercase.

Here’s an example of how you can use the UPPER function in a formula:

=IF(UPPER(A1)=”YES”, “APPROVED”, “DENIED”)

In this example, the UPPER function is used to convert the text in cell A1 to uppercase. The IF function then checks if the text is “YES” (in uppercase) and displays “APPROVED” if it is, or “DENIED” if it is not.

You can also nest the UPPER function within other functions, such as the LEFT or RIGHT functions, to convert only a part of the text to uppercase. For example:

=LEFT(UPPER(A1), 3)

This formula would convert the first 3 characters of the text in cell A1 to uppercase.

Here is another example that uses the UPPER function to compare two cells with case-insensitive matching:

=IF(UPPER(A1)=UPPER(B1), “MATCH”, “NO MATCH”)

In this formula, the UPPER function is used to convert the text in cells A1 and B1 to uppercase. The IF function then checks if the text in both cells is the same (ignoring case) and displays “MATCH” if it is, or “NO MATCH” if it is not.

I hope this tutorial has helped you understand how to use the UPPER function in Microsoft Excel.