Using the UPPER function to change text from lower - uppercase
In this example, we will be demonstrating how to convert text that is in lowercase to uppercase by using the UPPER Function. Here is the syntax that is used for the function:
UPPER(text)
text: Text to be converted to all uppercase letters. The text can be either a reference or a text string.
For our example, we have our text in column A beginning at Cell 2 that we need to convert to upppercase in Column B. Here is how we’ll do this:
How to convert text from Uppercase to Lowercase using the UPPER Function
- Enter you text in Column A from cells A2:A6
- Select Cells B2:B6 and type the following formula: =UPPER(A2).
- Press CTRL+Enter
You should now be set!
If you want to convert text from Upper to Lowercase, simply use the LOWER Function. For our example, you owuld use this formula: =LOWER(A2). This tip should work in Excel 97, 2000, 2003 and 2007.
