Capitalize First Letters in Google Sheets

Edited by Djinu, VisiHow, Eng, Anonymous and 1 other

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 | I need help

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 | I need help

  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 | I need help

  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 | I need help

  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 | I need help

  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 | I need help

    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 | I need help

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.

Comments

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




Djinu
Featured Author
365 Articles Started
403 Article Edits
21,200 Points
Djinu is a featured author with VisiHow. Djinu has achieved the level of "Lieutenant" with 21,200 points. Djinu has started 365 articles (including this one) and has also made 403 article edits. 96,500 people have read Djinu's article contributions.
Djinu's Message Board
Djinu: Hi, my name is Djinu.
Djinu: Can I help you with your problem about "Capitalize First Letters in Google Sheets"?
 

Article Info

Categories : Google

Recent edits by: Anonymous, Eng, VisiHow

Share this Article:

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

Do you have a question not answered in this article?
Click here to ask one of the writers of this article
x

Thank Our Volunteer Authors.

Would you like to give back to the community by fixing a spelling mistake? Yes | No