How To Make All Caps In Excel

Hello and welcome to my guide on how to make all caps in Excel! If you’re like me, you want your data to be consistent and professional-looking. I often find myself needing to convert text to all caps in Excel, and it’s a quick and simple process. Let’s dive into the details on how to achieve this.

Using the UPPER Function

One of the methods I frequently use is the UPPER function. This function converts all lowercase letters in a text string to uppercase. To utilize it, simply enter the following formula in an empty cell: =UPPER(cell_reference), where cell_reference is the reference to the cell containing the text you want to convert. Once you hit Enter, the text in the specified cell will instantly transform into all caps.

Applying Cell Formatting

Another approach I employ is utilizing Excel’s formatting options. To do this, select the cell or range of cells containing the text you want to convert. Then, navigate to the Home tab, click on the “Font” group, and select the “Uppercase” option. This will instantly change the selected text to all caps, ensuring uniformity and consistency across your data.

Combining with the SUBSTITUTE Function

Sometimes, I encounter scenarios where I want to retain the original text while also displaying it in all caps. In such instances, I combine the UPPER function with the SUBSTITUTE function. This allows me to create a new cell containing the original text in all caps while preserving the original text in its original format. Here’s an example formula: =UPPER(SUBSTITUTE(cell_reference, " ", " ")). In this case, the SUBSTITUTE function is used to replace spaces with spaces, effectively creating a replica of the original text but in all caps.


In conclusion, transforming text to all caps in Excel is a straightforward process that can be accomplished using various methods such as the UPPER function, cell formatting, and combining functions for specific requirements. By applying these techniques, you can ensure consistency and professionalism in your Excel spreadsheets. I hope you found this guide helpful, and may your data always be perfectly formatted!