Change Text Case in Google Sheets: Upper, Lower, Proper, Sentence

Have you ever needed to change the text case in Google Sheets? Whether you want to convert text to uppercase, lowercase, proper case, or even sentence case, Google Sheets has built-in functions to help you accomplish this. In this article, we’ll show you how to use these functions to easily change text case in Google Sheets.

What is each text case?

Before we dive into the how-to, let’s quickly go over what each text case means:

• Upper case: All letters in the text are converted to uppercase letters.
• Lower case: All letters in the text are converted to lowercase letters.
• Proper case: The first letter of each word is converted to uppercase letters, while all other letters are lowercase.
• Sentence case: The first letter of each sentence is converted to uppercase letters, while the rest remain unchanged.

How to Change Text to Upper, Lower, Proper Case in Google Sheets

To change the text case in Google Sheets, we can use built-in functions. Let’s take a look at how to do it for each case.

Upper Case

To convert text to uppercase in Google Sheets, we can use the UPPER function. This function converts all the characters in a text to capital letters.

The syntax for the UPPER function is as follows:

UPPER(text)

For example, if we have the text in cell A1 and want to convert it to uppercase, we can use the formula =UPPER(A1).

Lower Case

Conversely, if you want to convert text to lowercase in Google Sheets, you can use the LOWER function. This function converts all the characters in a text to lowercase letters.

The syntax for the LOWER function is as follows:

LOWER(text)

For example, to convert the text in cell A1 to lowercase, you can use the formula =LOWER(A1).

Proper Case

To convert text to proper case in Google Sheets, where the first letter of each word is capitalized and the rest are lowercase, we can use the PROPER function.

The syntax for the PROPER function is as follows:

PROPER(text)

For example, if we have the text in cell A1 and want to convert it to proper case, we can use the formula =PROPER(A1).

Sentence Case

Unlike the other cases, sentence case doesn’t have a built-in function in Google Sheets. However, we can still achieve it using a custom formula or function.

Let’s say we have the following text in cell A1:

This is a sentence. This is another sentence: This is a third sentence? Please correct ME

To convert this text to sentence case, we can use the following formula:

=ARRAYFORMULA(LET(
  textA, A1,
  testA, TOCOL(SPLIT(textA,". ",FALSE),1),
  textB, TEXTJOIN(". ",TRUE,REPLACE(testA,1,1,UPPER(LEFT(testA,1)))),
  testB, TOCOL(SPLIT(textB,": ",FALSE),1),
  textC, TEXTJOIN(": ",TRUE,REPLACE(testB,1,1,UPPER(LEFT(testB,1)))),
  testC, TOCOL(SPLIT(textC,"? ",FALSE),1),
  IFERROR(TEXTJOIN("? ",TRUE,REPLACE(testC,1,1,UPPER(LEFT(testC,1)))), )
))

By using this formula, we split the text into sentences, capitalize the first letter of each sentence, and then rejoin them.

Conclusion

Changing text case in Google Sheets can be a breeze with the built-in functions provided. Whether you need to convert text to upper, lower, proper, or even sentence case, Google Sheets has you covered. With these simple formulas, you can easily transform your text to match your desired case.

Now that you know these tricks, go ahead and make your text stand out in Google Sheets!

For more tips and tricks on Google Sheets, visit Crawlan.com.