Change Case to Lowercase in Google Sheets

Edited by Djinu, Alexander Avdeev, Eng, Anonymous and 1 other

You're watching VisiHow. In this video, we are going to show you how to change all of the letters to lowercase using Google Sheets. In this video, we have names listed in all capitals in column "A".

Go from uppercase to lowercase Google Spreadsheets.mp4-canvas36 218312.jpg

Ad

Steps

  1. 1
    We click cell "B1".
    Go from uppercase to lowercase Google Spreadsheets.mp4-canvas10 332069.jpg
    Advertisement
    Was this step helpful? Yes | No | I need help

  2. 2
    We type "=lower(".
    Go from uppercase to lowercase Google Spreadsheets.mp4-canvas15 264717.jpg
    Advertisement
    Was this step helpful? Yes | No | I need help

  3. 3
    We can either type "A1" or click cell "A1".
    Go from uppercase to lowercase Google Spreadsheets.mp4-canvas20 233479.jpg
    Was this step helpful? Yes | No | I need help

  4. 4
    We type ")".
    Go from uppercase to lowercase Google Spreadsheets.mp4-canvas21 652061.jpg
    Was this step helpful? Yes | No | I need help

  5. 5
    We press "Enter".
    The formula will change the text from all capital letters to all lowercase letters.
    Go from uppercase to lowercase Google Spreadsheets.mp4-canvas22 867993.jpg
    Was this step helpful? Yes | No | I need help

  6. 6
    We can fill the formula down by double-clicking or clicking and dragging the formula in the cell.
    Go from uppercase to lowercase Google Spreadsheets.mp4-canvas30 440861.jpg
    Was this step helpful? Yes | No | I need help

    Advertisement

That was how to change all of the capital letters to lowercase letters using Google Sheets. If you have any questions or comments, please leave them in the space below. Thanks for watching VisiHow!

Video: Change Case to Lowercase in Google Sheets

Questions and Answers

I don't want to use UPPER() or LOWER(), instead I would like a script to handle that?

I have got the values populated from the Google Form.I couldn't make the entry only in Proper or UPPER case.So, I thought if I have a Google Script which runs every time the sheet is opened or edited to automatically convert all the values to UPPER CASE. Thanks in advance. Regards. It explains only about using UPPER or LOWER functions. I need a script to run automatically. I have tried: I tried,

Was this helpful? Yes | No | I need help

function onEdit(e) {

 if (typeof e.value !== 'object') {
   e.range.setValue(e.value.toUpperCase());
 }

}. I think it was caused by: I am not sure whether all values are included. Should I use onEdit or onOpen trigger

Was this helpful? Yes | No | I need help

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. 97,700 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 "Change Case to Lowercase in Google Sheets"?
 

Article Info

Categories : Google

Recent edits by: Anonymous, Eng, Alexander Avdeev

Share this Article:

Thanks to all authors for creating a page that has been read 603 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