With Microsoft Excel’s UPPER , LOWER , and PROPER functions, you can make your text uppercase or turn it into lowercase or uppercase. You can specify your text as a cell reference or directly in the function. We’ll show you how.
Capitalize text using the UPPER function
If you want all the letters in your text to become uppercase (i.e. put your text in uppercase), specify your text in Excel’s UPPER function as follows.
First, in your spreadsheet, select the cell where you want to display the uppercase text.
Select a cell.
In the selected cell, type the following function and press Enter. In the function, be sure to replace B3 with the cell that contains the text you want to capitalize.
Enter the UPPER function.
If your text is not in a cell, specify the text directly in the function as follows. In this function, replace My text with the text you want to capitalize.
Excel will display the resulting uppercase text in the selected cell.
Uppercase text in Excel.
There you go, you’re ready.
How to convert text to uppercase, lowercase or lowercase in Excel?
Convert text to lowercase using LOWER function
To make all letters in your text lowercase, use Excel’s LOWER function as follows.
In your Excel spreadsheet, click the cell where you want to put the lowercase text.
Choose a cell.
In the selected cell, enter the following function and press Enter. In this function, replace B3 with the cell where your text is.
Use the LOWER function.
To specify the text directly in the function, use the function as follows. Here, replace Your Text with your own text.
You will see the resulting lowercase text in your current cell.
Lowercase text in Excel.
And that’s all.
Change text to uppercase using PROPER function
The PROPER function capitalizes the first letter of every word in your text. If you want to use this text formatting, use the PROPER function as follows.
First, in your worksheet, choose the cell where you want to display the result.
In the chosen cell, enter the following function and press Enter. Replace B3 with the cell containing the text you want to make uppercase.
Enter the PROPER function.
If you want to use the text directly in the function, use the function below. Here you will replace our text with your own text.
Excel will apply the appropriate case formatting and display the result in the cell of your choice.
Case-correct text in Excel.
Here’s how to use Excel’s various text functions to make your content uppercase, uppercase, and lowercase. Good job with the text in your spreadsheets!