In this article:

How to Change Case in Google Sheets (2024 Guide)

May 8, 2024

How to Change Case in Google Sheets

To change the case of text in Google Sheets, you can use various functions depending on the case you want to achieve.

Here are some common functions:

UPPER: Converts all letters in a specified string to uppercase.

Example: =UPPER(A1) would convert the text in cell A1 to uppercase.

LOWER: Converts all letters in a specified string to lowercase.

Example: =LOWER(A1) would convert the text in cell A1 to lowercase.

Here's how you can do it: 

1. Click on the cell where you want the converted text to appear.

2. Type the function and reference the cell containing the text you want to convert. For example, =UPPER(A1) if you're converting the text in cell A1 to uppercase.

change case in google sheets

3. Press Enter, and the converted text will appear in the selected cell.

google sheets title case

Changing to Title Case in Google Sheets

The simplest way to change your text to title case in Google Sheets is to use the PROPER function. This function converts a specified string to title case, where the first character in each word is capitalized.

Below is how you can use the function:


So, if you have a string in cell A1 and you want to convert it to title case, you would use: =PROPER(A1). Here's an example:

title case google sheets
google sheets sentence case

Advanced Custom Function (for more control): If you need more control over which words are capitalized (for instance, if you don't want to capitalize certain conjunctions, prepositions, or articles), you might need to write a more complex custom formula or use Google Apps Script.

Remember, the PROPER function will capitalize every word, which might not be suitable for all types of titles (e.g., APA or MLA title case rules). For more nuanced control, a script would be required.

Changing to Sentence Case in Google Sheets

To convert text to sentence case in Google Sheets, where only the first letter of the sentence is capitalized, you'll need to use a combination of functions since there's no built-in sentence case function.

Here's a formula you can use:


This formula works as follows:

LEFT(A1,1) extracts the first character of the text in cell A1.

UPPER(LEFT(A1,1)) converts this first character to uppercase.

MID(A1,2,LEN(A1)) extracts the rest of the text from the second character to the end.

LOWER(MID(A1,2,LEN(A1))) converts this extracted portion to lowercase.

The & operator then concatenates these two parts.

Here's an example:

sentence case google sheets
sentence case in google sheets

Remember that this formula only capitalizes the first letter of the entire cell content and not the first letter of each sentence within a cell.

We hope that this article has helped you and given you a better understanding of how to change the case of text in Google Sheets. If you enjoyed this article, you might also like our articles on how to insert a check mark in Googe Sheets and how to make a bell curve in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->