How to make all letters capital in Excel
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-How-to-make-all-letters-capital-in-Excel.png)
Microsoft Excel offers a very interesting way to make all letters capital. We can cater to this problem statement by using the “=UPPER()” formula. We can perform the below mentioned way to make all letters capital in excel:
We’ll learn about this methodology step by step.
To do this yourself, please follow the steps described below;
Step 1 – Excel sheet with a lowercase text in a cell
![](https://spreadcheaters.com/wp-content/uploads/Step-1-How-to-make-all-letters-capital-in-Excel.png)
– Open the desired Excel workbook containing a lowercase value in a cell
Step 2 – Apply the formula
![](https://spreadcheaters.com/wp-content/uploads/Step-2-How-to-make-all-letters-capital-in-Excel.png)
– Now apply the formula “=UPPER(“ and then reference the cell where the lowercase text is present, and then hit Enter.
Step 3 – Letters made capital
![](https://spreadcheaters.com/wp-content/uploads/Step-3-How-to-make-all-letters-capital-in-Excel.png)
– We can see that all the letters have been made capital