In this article, we explain how to capitalize all letters in Google Sheets across multiple cells. Read on to learn more.
To capitalize all letters across multiple cells in Google Sheets, you can use the UPPER function. This function converts all lowercase letters in a text string to uppercase. Here's how to apply it:
Let's assume you have a list of names in column A, from A1 to A4:
Click on an empty cell where you want the capitalized results to appear. For example, click on B1.
In cell B1, type the following formula:
=UPPER(A1)
This formula converts the text in cell A1 to uppercase.
Click and drag the small dot in the lower-right corner of B1 down to the other cells where you want to apply the same formula (B2, B3, B4).
If you want to replace the original data with the capitalized text, first select cells B1 to B4. Right-click and choose "Copy." Then select cell A1, right-click, and under "Paste special," choose "Values only."
We hope that this article has helped you and given you a better understanding of how to capitalize all letters in Google Sheets. If you enjoyed this article, you might also like our articles on how to capitalize the first letter in Google Sheets and how to clear conditional formatting in Google Sheets.
