How to change case in Google Sheets: UPPER, lower, Capitalize Each Word, Sentence case, tOGGLE

Changing text case in Google Sheets may seem an intricate task as there is no such option in the standard menu. Even so, the task is very much resolvable. In this blog post, I share different ways to capitalize your words or turn them into lowercase, uppercase, and sentence case.

Format text in Google Docs

When you don't find the easy way to change the case in Google Sheets, the first alternative that may come to mind is Google Docs — the service where this option exists in the menu. But since you're in Sheets, you'll need to get your data to Docs first:

  1. Select your records in spreadsheets:
    • You can select the required data range manually.
    • Select all records from one column using Ctrl+Shift+down arrow
    • Or select the entire used range with Ctrl+A
      Select data in Google Sheets.
  2. Once records are selected, copy them by pressing Ctrl+C
  3. Open the new Google Doc and press Ctrl+V to paste the copied data there.
  4. Then select it once again, go to Format > Text > Capitalization, and there you'll see 3 ways Google Docs changes cases: lowercase, UPPERCASE, Title Case:
    Google Docs capitalization menu.
  5. Click whatever option is necessary to change your text case, and then just copy-paste the data back to Google Sheets:
    The text is converted to lowercase.

If you ask me, this way may do if you have a small dataset and some extra minutes to shift records back and forth. But if neither is about you, it's better to use one of the alternatives Google Sheets offers to change text case right there.

Google Sheets functions to change case

Functions are the only standard way to change case in Google Sheets. Be ready to prepare extra column(s) where you will have to enter formulas and see the result.

Tip. If you don't like functions or have no time nor desire to learn them, jump right to the part where I introduce you to a special tool. With it, you'll just click the required option and it will do the rest for you.

PROPER function — capitalize all words

The PROPER function is used in Google Sheets to capitalize the first letter of all words in a cell:

PROPER(text_to_capitalize)

It requires only one argument: a text where you want to change the case or a reference to a cell with that text.

Since my data is in the column, I will reference its cells using the Google Sheets PROPER function in the neighbouring empty column:

=PROPER(A2)

Once I enter the formula, Google Sheets offers to copy it down for me and capitalize the first letters in all cells:
Autofill the column with the formula to capitalize each word.

You can either press Ctrl+Enter or click the tick icon to allow spreadsheets to do that.

Tip. If that doesn't happen in your file, you can copy the formula down the column manually using one of the ways described here.

And here you go, the entire column in Google Sheets where you capitalized the first letter in each word:
Capitalize all words in Google Sheets.

You can go further and build an array formula that will capitalize each word in the entire column at once:

=ArrayFormula(PROPER(A2:A9))

Capitalize all words within the column with ArrayFormula.

Tip. To get rid of the formulas eventually and turn records into editable values, follow the instructions from this blog post.

UPPER function

The next one to change case is the UPPER function in Google Sheets. As you may have guessed, it capitalizes every single character in a cell. The entire text will be written in the upper case.

It also requires only one argument — the text to convert to uppercase:

UPPER(text)

I'm going to enter it in B2 while referencing A2 and then copy it down the column as well:

=UPPER(A2)

Google Sheets and uppercase column.
To make the text in Google Sheets uppercase in the entire column with one formula right away, the same ArrayFormula will help:

=ArrayFormula(UPPER(A2:A9))

Use ArrayFormula in Google Sheets to turn the entire column to upper case.

Tip. And again, to convert formulas to values, use one of the ways described in this blog post.

LOWER function

Last but not least, it is the LOWER function. Yes, it turns all text into lowercase :)

As the 2 aforementioned functions, this one also needs just 1 thing: text or a reference to a cell with the text:

LOWER(text)

Let's change case in the same Google Sheets uppercase column from the example above. This time, I will turn it to lowercase:

=LOWER(A2)

Change text case in Google Sheets to lowercase.

And even if you know it already, I will still show you how it looks when the ArrayFormula automatically populates all cells in a range you specify with the result:

=ArrayFormula(LOWER(A2:A9))

Turn text in all uppercase to all lowercase in Google Sheets.

Tip. If necessary, turn formulas into values as shown in this blog post.

Apply Sentence case using functions

Sentence case is yet another way to present your text. If you want your cells to appear as sentences, it means that you want Google Sheets to make only the first letter of each cell capital without changing case of other letters.

Sadly, there's no special function in spreadsheets as there is for the proper text case, for example.

Even so, there is a combination of other functions for Google Sheets that produce a formula that eventually capitalizes only the first letter in cells. I'm not going to lie — it's not the easiest one and it is definitely a bit of a learning curve.

Let me show you the formula first, and then I'll explain how it works:

=JOIN(". ",ArrayFormula (REPLACE(TRIM(SPLIT(A2,".")),1,1,UPPER(LEFT(TRIM(SPLIT(A2,".")),1)))))

Change case in Google Sheets: make the first letter capital.

I duplicated the contents in some cells (so there are sentences) and highlighted them grey so you could better understand what's happening before the case is changed (see cells A2, A6, A9 in the screenshot above):

  1. If there are several sentences in a cell, SPLIT(A2,"." ) divides them into separate cells by a period.
  2. Then TRIM enfolds those sentences and removes all excess spaces.
  3. The part at the end of the formula — UPPER(LEFT(TRIM(SPLIT(A2,"." )),1)) — not just splits the contents but also extracts and capitalizes only the first letter (the LEFTmost one) of each sentence.
  4. REPLACE — well — replaces the first lowercase letters of all sentences with their uppercase equivalents.
  5. When sentences are split, Google Sheets sees them as an array of cells. To make sure all split sentences are processed, I wrap everything in ArrayFormula.
  6. And finally, JOIN collects those individual sentences back into their cells.

If this formula still makes you procrastinate — I feel you. The last method I'm going to share with you is much easier. It's actually my favorite since in order to change the text case I only need to select the range and press two buttons. Come take a look.

Change case add-on for Google Sheets

No matter the formula you use, all of them — plain and complicated — require an extra column to reside. And if later you turn those formulas into editable values, it will take even more time and effort.

Luckily, we have the simplest formula-free solution to change the text case in Google Sheets: Power Tools add-on. It's a collection of 30+ utilities for spreadsheets that includes the Change case tool.

Tip. Watch this video to get to know the tool better, ot feel free to read the short introduction right below it.

Changing case in Google Sheets with this add-on is as easy as pie:

  1. Select the range.
  2. Choose the required case:
    Power Tools and its Change case add-on for Google Sheets.
  3. Press Run.

See for yourself, I will change the case in all 5 ways in a few seconds:
Change case in 5 different ways with Power Tools.

Note. When you choose to apply Sentence case, it will only capitalize the first letter of each cell/sentence. It will not lower other letters in order not to corrupt any abbreviations or names you may have. If you want to lower all other letters anyway, you will need to apply lowercase first.

In addition to 4 cases that can be covered with formulas — Sentence case, Capitalize Each Word (proper case), upper and lower case — we also make it possible to tOGGLE tEXT. It means changing all letters in uppercase to lowercase and vice versa.

The add-on even features a couple of extra settings:

  • Ignore abbreviations will take care of acronyms if any for the Capitalize Each Word option.
  • Ignore formulas will skip cells with formulas (for all 5 cases) in order not to turn them into values.

If you choose the add-on — there are no extra columns, no formulas, no need to convert formulas into values. The process is as easy and straightforward as possible.

You can install your Power Tools from the Google Store and try changing the text case in Google Sheets on your own. These instructions will help you out as well.

Whatever way you choose as your go-to, if you have any questions about it, please ask them in the comments section below.

You may also be interested in: