How To Change Case In Google Sheets

In this tutorial, you will learn how to change case in Google Sheets.

When you’re working in Google Sheets, you may find you need to change the case of certain text. For example, you might want to change to all caps to draw attention to a section header. Before you take the time to retype the text in the desired case, read the following instructions to learn how to change case using Google Sheets formulas

Uppercase

The function to change text to all uppercase is UPPER(). Here’s how to use it:

Step 1

Select a cell to display the uppercase text and type the following formula: “=UPPER(A2)” where A2 is the cell containing the text to change

Step 2

You can also type the text directly into the formula surrounded by quote marks: “=UPPER(“text to change”)

Lowercase

The function to change to lowercase is LOWER(). Use it in the same way as the UPPER() function describe above

Proper Case

Proper case is when the first letter of each word is capitalized and all other letters are lowercase. It is often used for headings and labels.

The function to change text to proper case is PROPER() and it works the same as the UPPER and LOWER functions.

Summary

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to change case in Google Sheets. Want more? Check out all the Google Sheets Tutorials.

Get more Google Sheets stuff

Subscribe to our mailing list and get interesting Google Sheets stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.