Capitalize First Letters in Google Sheets

Edited by Djinu, VisiHow, Eng, Chirag Bhutani

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.

Was this helpful? Yes | No
Capitalize first letters on Google Spreadsheets.mp4-canvas49 291996.jpg

Ad

Steps

  1. 1
    Click the "B1" cell
    .
    Capitalize first letters on Google Spreadsheets.mp4-canvas27 526287.jpg
    Advertisement
    Was this step helpful? Yes | No
  2. 2
    Type "=proper(A1)"
    .
    Alternatively, instead of typing "A1", you can just click the "A1" cell.
    Capitalize first letters on Google Spreadsheets.mp4-canvas32 067997.jpg
    Advertisement
    Was this step helpful? Yes | No
  3. 3
    Next, press "Enter"
    .
    You'll see that the cell will have the capitalized text from the other cell.
    Capitalize first letters on Google Spreadsheets.mp4-canvas40 448996.jpg
    Was this step helpful? Yes | No
  4. 4
    If you want to fill the cells down, you can just click on the cell
    .
    Capitalize first letters on Google Spreadsheets.mp4-canvas44 75644.jpg
    Was this step helpful? Yes | No
  5. 5
    Then, double-click the cell or click and drag it by the corner to fill down
    .
    Capitalize first letters on Google Spreadsheets.mp4-canvas47 05644.jpg
    Was this step helpful? Yes | No
    Advertisement

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!

Was this helpful? Yes | No

Video: Capitalize First Letters in Google Sheets

Questions and Answers

I want only first letter of First word to be capitalized in sentence?

I want that the first letter of the first word in the sentence should be in capital and rest words in small characters. Can you help me in this?. I have tried: I have tried B = proper(A)

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

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 post in the comments section below.

Comments

VisiHow welcomes all comments. If you do not want to be anonymous, register or log in. It is free.

Article Info

Categories : Google

Recent edits by: Eng, VisiHow, Djinu

Share this Article:

Thanks to all authors for creating a page that has been read 820 times.