How to Capitalize All Letters in Google Sheets | Scribe

How to Capitalize All Letters in Google Sheets

  • Alejandra Arciniegas |
  • 0 step |
  • 52 seconds
  • Google SheetsGoogle Sheets
Let's see how to capitalize all the letter from a text in Google Sheets. This is actually a pretty simple process, that you can accomplish with a couple of formulas. \ But first things first: open the spreadsheet document you are working on.
Then, click on the cell where you want your capitalized text to be.
Type "=upper"
Then, select the "UPPER" option that will appear below.
Now, select the cell that contains the text you want to capitalize, close the bracket and hit enter.
You will get your capitalized text. Also, Google Sheets might suggest you to capitalize other texts that are near, so, if you want to, you can accept the suggestion.
Let's see how to capitalize multiple texts now! First, select the cell where you want the first text to be located.
Type "=array"
Now, click on the "ARRAYFORMULA" option that appears below.
Now, open another bracket and type "upper"
Click on the "UPPER" option that appears below.
Click on the first cell of the group of cells you want to capitalize.
follow it by a ":" and the coordinates of the last cell of the group. In this case, the formula would be: **=ARRAYFORMULA(UPPER(a3:a10)**
That's all!
Documents you might like
0 Selected
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe