How to Change Text Case in Google Sheets [Complete Guide]

How to Change Text Case in Google Sheets 12

Today our topic is how to change text case in google sheets. First, we will know what is a “text case”. Text cases are different categories of capitalization of words in sentences in different orders. These cases are used in different scenarios while writing. There are four text cases in google sheets.

  • Sentence case
  • Lower case
  • Upper case
  • Proper case

Sentence case: It capitalizes the first letter of each sentence.

Lowercase: It changes the text from uppercase to lowercase.

Upper case: It capitalizes all the letters of your text.

Proper case: Proper case, or Title case text is written with each of the first letters of every word being capitalized. Let me show you an example of all cases for better understanding.

How to Change Text Case in Google Sheets 1

Hope you got it. What is a text case? In google sheets, while making any kind of document there is a need to change text cases, therefore I wrote this article to make you aware of how to change text cases in google sheets.

Importance of changing Text Case in Google Sheets

As we know that Google sheets are commonly used for data analysis, financial reports, or any other spreadsheet document, which consists of text, numbers, characters, etc. According to documents, there are different kinds of text, somewhere capital, and somewhere lower case, and also includes headings and sentences.

Therefore we have to change the text case where it is needed. If you are writing a heading or title you will use e title case, or if you are writing sentences you will use sentence case, similarly, sometimes it is needed to capitalize all words we will use upper case and the same as the lower case for small letters. That looks much needed in google sheets.

See also  How to Use HLOOKUP Function in Google Sheets (User Guide)

How to Change Text Case in Google Sheets

Unfortunately, In Google sheets, there is not any default option present in the menu to change text cases as google docs have. But there are some different ways to resolve this difficulty. Here we will study three methods to change cases in google sheets.

  1. Change the text case by using the formula in Google Sheets
  2. Change the text case by using Add-Ons in Google Sheets
  3. Change the text case with the help of Google docs.

How to Change Text Case in Google Sheets – Using Formula

The first and fastest way to change text cases in Google Sheets is by using formulas

Syntax            

For Upper case                            For Lower Case                For Proper Case

=Upper(“text”)                              =Lower(“text”)                  =Proper(“text”)

You may also use the cell address instead of text like,

=Upper(cell range)

=Lower(cell range)

=Proper(cell range)

Let’s be practical with the help of an example.

Step 1

First, we will have some samples of data.

How to Change Text Case in Google Sheets 2

Step 2

For the upper case, we will use the syntax of upper case, first, we will write the formula for which text case we want.

How to Change Text Case in Google Sheets 3

Step 3

Now give the address of the cell that you want to capitalize or change text into upper case.

How to Change Text Case in Google Sheets 4

Step 4

Now just press “Enter” and the result will be shown as,

How to Change Text Case in Google Sheets 5

As you may see the text you selected has been changed to uppercase.

Step 5

Now similarly for a lower case, we will just replace the syntax upper lower like

How to Change Text Case in Google Sheets 6

Step 6

Now again give the cell range that you want to change in lowercase.

How to Change Text Case in Google Sheets 7

Step 7

Press “Enter’ to see the result.

How to Change Text Case in Google Sheets 8

Step 8

For proper text, we will write the syntax of the proper case and will give the cell address.

How to Change Text Case in Google Sheets 9

Step 9

Now by pressing just one click “Enter”, your text will convert into Proper text.

How to Change Text Case in Google Sheets 10

See also  Conditional Formatting based on Another Cell in Google Sheets

How to Change Text Case in Google Sheets – using ARRAYFORMULA

You may also use ARRAYFORMULA here to change the text case of a row or column in a table or data. If you are familiar with the ARRAYFORMULA then you will not find any problem using it but if you do not then do not worry here I will explain an example.

Syntax:  =ARRAYFORMULA(upper(cell range))

Step 1

Just write the syntax with the case that you require and then give the range of cells that you want to change.

How to Change Text Case in Google Sheets 11

Step 2

Now just press “Enter” to get the result, it will change the text case of all the selected cells. As you may see,

As we discuss that we may also use “text” instead of cell range to change the text cases. Let’s do an example of this as well.

How to Change Text Case in Google Sheets 12

Step 1

First, we will write the syntax in which case we are looking for, For example, If we want to change the text in upper case then the syntax will be written as

How to Change Text Case in Google Sheets 13

Step 2

Now type the text you want to change in upper case.

How to Change Text Case in Google Sheets 14

Note:  Must write the text between inverted commas.

Step 3

Now just press “Enter” Your text will appear.

How to Change Text Case in Google Sheets 15

We didn’t talk about “Sentence Case” because in Google sheets the default text case is Sentence case you don’t need to change it. If you want to write text in sentence case, start writing without changing any text case.

How to Change Text Case in Google Sheets – Using Add-On

Google sheets provide you with Add-ons to change text cases instantly with one click only. You also don’t need a second column to the other side to change text cases as we did by formulas. Add-Ons also get rid of remembering formulas. It includes some additional features as well and different cases as well. Once you install a change case tool you may change the text case in one click. Let me show you how it works.

Step 1

In the menu bar go through the Extensions>Add-Ons>Get add-ons.  As you may see below

How to Change Text Case in Google Sheets 16

Step 2

A new pop-up window will appear in front of you consisting of different kinds of Add-ons. To find your tool go into the search box and search for “change case”.

How to Change Text Case in Google Sheets 17

Step 3

In the result, you will see many different add-ons of different developers. Choose any one of them which seems suitable to you.

How to Change Text Case in Google Sheets 18

Step 4

Now simply install it by clicking on the “install”. It will also ask for a login to an account and some permissions from your account, click on the blue button to allow it.

How to Change Text Case in Google Sheets 19

Step 5

Once you complete the installation of add-ons. You will find it in the menu bar “Extensions”.

How to Change Text Case in Google Sheets 20

Step 6

Where you may see all the text cases that you required.

How to Change Text Case in Google Sheets 21

Step 7

Now you may use it easily, just select the cells that you want to change in the text case, go through the add-ons you installed and click on the desired case.

How to Change Text Case in Google Sheets 22

Step 8

As you may see, by just clicking once, your font has been changed to upper case as you selected.

How to Change Text Case in Google Sheets 23

Step 9

Similarly for any case simply apply the same attempt as above and select your desired text case. This time we will go for lowercase.

How to Change Text Case in Google Sheets 24

Step 10

As result is at the front in the form of lowercase as we may see.

How to Change Text Case in Google Sheets 25

You may also change the text case of multiple cells, rows, columns, or a table. Just select the text that you want to change in the text case and go into the option of installed add-ons and select the required case by just one click you will get all the selected text changed.

See also  How to Add Error Bars and Data Labels to Charts in Google Sheets

How to Change Text Case in Google Sheets – Using Google Docs

The above methods are good enough to change text cases in google sheets. But you may have some problems with the above method, such as in the formula method you will unlike text change in another side column similarly sometimes user face problems due to installing add-ons as well or sometimes add-ons do not work after installing. So, therefore, here I am going to tell you one more easy method. In this method, we can change the text case with the help of google docs. As we know google docs have the default option of changing the text in the menu bar from where we can change our text case by copy-pasting.

Step 1

Select the text in google sheets that you want to change the text case and copy it.

How to Change Text Case in Google Sheets 26

Step 2

Now open google docs and paste the text.

How to Change Text Case in Google Sheets 27

Step 3

Fortunately, in google docs, you will find the capitalization option in the text format option in the menu bar. From where you can change the text case. Here we are going to select the upper case to test.

How to Change Text Case in Google Sheets 28

Step 4

As you can see your text has been capitalized, now copy it to paste it into google sheets.

How to Change Text Case in Google Sheets 29

Step 5

As we required our text has been changed into our desired text case.

How to Change Text Case in Google Sheets 30

Important Notes

  • Unfortunately, there is not any by-default button by which you may change the text cases in google sheets.
  • Remember while applying the change text case formula with text that, when you write the formula must use inverted commas while typing text in the syntax otherwise you will get the error.
  • A disadvantage of using the formula method is that it requires a new column to change the text case. You can’t change the text case in the same column even if you can’t copy from the resultant column.
  • When you add an add-on in Google Sheets, it’s only available in the document in which you added it. If you open another Google Sheet document or a new one, you will have to add this again to use it.

See also  How to Convert Text to Numbers in Google Sheets

Conclusion

Changing text cases is a very necessary option in any spreadsheet or document software. But unfortunately, google sheets does not have such kind of options but hope soon updated. Therefore we found some difficulties while changing the text case but we resolve them with better substitutes with different methods as we study above hope it will found helpful to you thanks keep in touch with Office Demy.

Content Protection by DMCA.com

M. Shaiq Ansari

Hi, I am Shaiq. A young and self-motivated content writer having years of experience expertise in MS Office suite, Google docs Editor Suite. I have a technical education background that empowers me to stand out in today's digital world. I am currently a freelance content creator and a part of a local digital marketing agency in Karachi Pakistan.

OfficeDemy.com
Logo
Enable registration in settings - general