Have you ever wondered how to capitalize the first letter in Google Sheets? Look no further! In this article, we’ll show you a few simple steps to achieve this in no time.
Default Capitalization Settings in Google Sheets
When you create a new spreadsheet in Google Sheets, the default capitalization settings are set to “Automatic.” This means that all cells will be automatically capitalized according to the following rules:
- Each sentence begins with a capital letter.
- Proper nouns, such as names of people, places, or things, are capitalized.
- All other letters are lowercase unless they appear at the beginning of a sentence.
Capitalizing the First Letter of Each Word
In some situations, you may need to capitalize the first letter of each word in a sentence or phrase. Here’s a simple formula to achieve this:
Difficulty: Beginner
Estimated Time: 5 seconds
- Select the cell where you want to display the result.
- Go to the formula bar and type “=UPPER(A1)”, where “A1” is the cell containing the text.
- Press the Enter key on your keyboard.
And voila! With this formula, each word will be capitalized.
Capitalizing Only the First Letter in a Cell
If you simply want to capitalize the first letter of a cell, follow these steps:
Difficulty: Beginner
Estimated Time: 7 seconds
- Click on an empty cell.
- Go to the formula bar and type “=REPLACE(A2, 1, 1, UPPER(LEFT(A2, 1)))”. Here, “A2” is the cell containing the text.
- Press Enter.
There you have it! That’s the result!
Capitalizing Each Word in a Column
To extend the range of your formula and capitalize all words in an entire column, follow the steps below:
Difficulty: Beginner
Estimated Time: 7 seconds
- Select an empty cell.
- In the formula bar, enter the formula “=ARRAYFORMULA(UPPER(A1:A))”, where “A1:A” is the range of cells.
- Press the Enter key on your keyboard.
It’s as simple as that!
Capitalizing the First Letter of a Substring
To capitalize the first letter of a substring, follow the illustrated steps below:
Difficulty: Beginner
Estimated Time: 7 seconds
- Select the empty cell where you need the result.
- Go to the formula bar and enter the formula “=UPPER(LEFT(A1, 1))&RIGHT(A1, LEN(A1)-1)”. Here, “A1” contains the text.
- Press Enter.
- Drag the icon in the bottom right corner of the cell downwards to copy the formula for the rest of your list if necessary.
There you have it! That’s all it takes!
Automatically Capitalizing the First Letter in Google Sheets
If you want to automatically capitalize the first letter, use the following solution:
Difficulty: Beginner
Estimated Time: 3 seconds
- Select the cell that already contains the result, as well as the empty cells below where you also want to apply the formula.
- Press Ctrl + Enter.
This will copy the formula to the other cells.
Alternatively, you can select the cell containing the result and drag it downwards to copy the formula to the cells below.
Take a look at the result below!
Now that you know how to capitalize the first letter in Google Sheets, you can easily format your data in a professional and appealing manner. Don’t forget to visit Crawlan.com for more Google Sheets tips and tricks.
Happy capitalizing!
