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
  2. 2
    We type "=lower("
    .
    Go from uppercase to lowercase Google Spreadsheets.mp4-canvas15 264717.jpg
    Advertisement
    Was this step helpful? Yes | No
  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
  4. 4
    We type ")"
    .
    Go from uppercase to lowercase Google Spreadsheets.mp4-canvas21 652061.jpg
    Was this step helpful? Yes | No
  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
  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
    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

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

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

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

Share this Article:

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