Capitalize First Letters in Google Sheets

4 Parts:

Steps

Video: Capitalize First Letters in Google Sheets

Questions and Answers

Comments

You're watching VisiHow. In this video, we're going to show how to capitalize the first letter using Google Sheets. In this video, we have a list of names in column "A". They are typed in lowercase, but we want each word to start with a capital letter.

1. 1
   Click the "B1" cell

   .

   

   Was this step helpful? Yes | No| I need help
2. 2
   Type "=proper(A1)"

   .

   Alternatively, instead of typing "A1", you can just click the "A1" cell.

   

   Was this step helpful? Yes | No| I need help
3. 3
   Next, press "Enter"

   .

   You'll see that the cell will have the capitalized text from the other cell.

   

   Was this step helpful? Yes | No| I need help
4. 4
   If you want to fill the cells down, you can just click on the cell

   .

   

   Was this step helpful? Yes | No| I need help
5. 5
   Then, double-click the cell or click and drag it by the corner to fill down

   .

   

   Was this step helpful? Yes | No| I need help

That was how to capitalize just the first letter for each word in cells using Google Sheets. If you have any questions or comments, please leave them in the space below. Thanks again for watching VisiHow!

Can you do this when the field is already occupied?

Trying to capitalize the first letter of every word on a sheet that's already complete

VisiHow QnA. This section is not written yet. Want to join in? Click EDIT to write this answer.

If you have problems with any of the steps in this article, please ask a question for more help, or post in the comments section below.

Comments