Sentence Case In Google Sheets

What Is Sentence Case In Google Sheets?

Sentence case in Google sheets is a set of functions used to change the text case. In Google sheets, there are three features. They are – UPPER case, LOWER case and PROPER case. For example, consider the below example showing text in cell A2.

Now, using sentence case text functions, we can change the text case into upper case, lower case and proper case as shown in the below image.

Likewise, we can change the text case in upper, lower and proper case using sentence case in Google sheets. In this article, let us learn how to change text in sentence case using examples.

Sentence Case() Google Sheets Formula

Sentence Case in Google sheets itself is not a formula but is used to change the text case in Google sheets.

We can use three different formulas to change text into sentence case in Google sheets.

They are:

• Upper Case
• Lower Case
• Proper Case

UPPER CASE()

The formula or syntax of upper case is =UPPER(text) where text denotes the text string to be altered in google sheets.

LOWER CASE()

The formula of lower case is =LOWER(text) where text denotes the text string to be altered in google sheets.

PROPER CASE

The formula or syntax of proper case is =PROPER(text) where text denotes the text string to be altered in google sheets.

How To Change Sentence Case In Google Sheets?

Let us learn how to change sentence case in Google sheets with the following steps.

Step 1: To begin with, we need to click on the cell where we want to change the text.

Step 2: Next, insert the =UPPER( formula to change the text string into capital letters.

(Similarly, we need to insert the =LOWER( function to change the text string into small letters and =PROPER( function to change the text string into sentence case or title case)

Step 3: Press Enter key.

By following these steps, we can change the text into lower, upper or proper case in Google sheets.

Upper Case

For example, consider the below table showing characters from the movie Harry Potter.

Note that the names of the characters are in mixed case. We can see the names in capital and small letters.

Now, let us learn how to change the sentence case in Google sheets with the following steps.

The steps are:

Step 1: To begin with, we need to click on the cell where we want to change the text. In this example, it is cell B2.

Step 2: Next, insert the =UPPER( formula to change the text string into capital letters.

And select the cell reference, A2 as the argument.

Step 3: Press Enter key.

Now, we can see the title case is replaced. In other words, we can see the text in upper case.

Now, using AutoFill option, we can change the text string of other data as shown in the below image.

Likewise, we can use uppercase function in Excel.

Lower Case

Now, let us learn how to change the text in lower case in Google sheets with the following steps.

The steps are:

Step 1: To begin with, we need to click on the cell where we want to change the text. In this example, it is cell C2.

Step 2: Next, insert the =LOWER( formula to change the text string into small letters.

And select the cell reference, A2 as the argument.

Step 3: Press Enter key.

Now, we can see the title case is replaced. In other words, we can see the text in lower case.

Now, using AutoFill option, we can change the text string of other data as shown in the below image.

Proper Case

Now, let us learn how to change the text into title case in Google sheets with the following steps.

The steps are:

Step 1: To begin with, we need to click on the cell where we want to change the text. In this example, it is cell D2.

Step 2: Next, insert the =PROPER( formula to change the text string into title case letters.

And select the cell reference, A2 as the argument.

Step 3: Press Enter key.

Now, we can see the title case is replaced. In other words, we can see the text in proper case.

Now, using AutoFill option, we can change the text string of other data as shown in the below image.

Likewise, we can use sentence case in Google sheets to change the text format.

Examples

Let us have a look at the following examples.

Example #1 – Change Text To Upper Case

Consider the below table showing proverbs in column A.

Now, we need to change the proverbs into upper case (capital letters) in Google sheets.

The steps are:

Step 1: To begin with, we need to click on the cell where we want to change the text. In this example, it is cell B2.

Step 2: Next, insert the =UPPER( formula to change the text string into capital letters.

And select the cell reference, A2 as the argument.

Step 3: Press Enter key.

Now, we can see the title case is replaced. In other words, we can see the text in upper case.

Now, using AutoFill option, we can change the text string of other data as shown in the below image.

Likewise, we can use uppercase function in Excel.

Example #2 – Change Text To Lower Case

Consider the below table showing products in column A.

Now, we need to change the name of the products into lower case (small letters) in Google sheets.

The steps are:

Step 1: To begin with, we need to click on the cell where we want to change the text. In this example, it is cell B2.

Step 2: Next, insert the =LOWER( formula to change the text string into small letters.

And select the cell reference, A2 as the argument.

Step 3: Press Enter key.

Now, we can see the title case is replaced. In other words, we can see the text in lower case.

Now, using AutoFill option, we can change the text string of other data as shown in the below image.

Likewise, we can use lower function in Excel.

Example #3 – Change Text To Proper Case

Consider the below table showing places in column A.

Now, we need to change the proverbs into proper case (title case format) in Google sheets.

The steps are:

Step 1: To begin with, we need to click on the cell where we want to change the text. In this example, it is cell B2.

Step 2: Next, insert the =PROPER( formula to change the text string into title case format.

And select the cell reference, A2 as the argument.

Step 3: Press Enter key.

Now, we can see the title case is replaced. In other words, we can see the text in proper case.

Now, using AutoFill option, we can change the text string of other data as shown in the below image.

Likewise, we can use proper function in Excel.

Important Things To Note

• Sentence case in Google sheets has three functions which are inbuilt.
• These functions are similar to that of Microsoft Excel’s three functions – UPPER, LOWER, PROPER
• We need to remember to select the right cell reference as argument as the text in the cell will be altered instantly.

Frequently Asked Questions

Download Template

This article must help understand Sentence Case In Google Sheets with its formulas and examples. You can download the template here to use it instantly.

Recommended Articles

Guide to What Is Sentence Case In Google Sheets. Here we explain how to change sentence case in Google Sheets using formula with its examples and points to remember. You can learn more from the following articles. –

Show Formula In Google Sheets

Percentage In Google Sheets

SUMIF Between Two Dates In Google Sheets