Change Case to Lowercase in Google Sheets

Edited by Djinu, Alexander Avdeev, Eng, j10 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.

My question is same as the last one posted but not yet answered?

I want the data entered through the form to be automatically upper case in the spreadsheet. also having problems with new data being formatted as existing data -- columns centered, etc. There is a question at the end where users says he doesn't want to use Lower and Upper functions -- I know how to do that. is there script to convert when the new entry is made that can convert to upper case and enter certain columns? I have tried: Nothing, I'm looking for solutions to try or for others who have the same issues. I think it was caused by: Not sure it's a problem, but my end user wants all upper case and certain columns centered.

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.

Referencing this Article

If you need to reference this article in your work, you can copy-paste the following depending on your required format:

APA (American Psychological Association)
Change Case to Lowercase in Google Sheets. (2016). In VisiHow. Retrieved Mar 25, 2017, from http://visihow.com/Change_Case_to_Lowercase_in_Google_Sheets

Was this helpful? Yes | No | I need help

MLA (Modern Language Association) "Change Case to Lowercase in Google Sheets." VisiHow, visihow.com/Change_Case_to_Lowercase_in_Google_Sheets Accessed 25 Mar 2017.

Chicago / Turabian VisiHow.com. "Change Case to Lowercase in Google Sheets." Accessed Mar 25, 2017. http://visihow.com/Change_Case_to_Lowercase_in_Google_Sheets.

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

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

Ask the author

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. 118,000 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: j10, Eng, Alexander Avdeev

Share this Article:

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