Google Doc Spreadsheet – Change Text to Upper, Lower and Sentence Case
We have a separate section on Info Inspired completely dedicated to Google Doc Spreadsheet Tutorials. In this post we can learn how to change any text in Google Doc Spreadsheet to Lower Case, Sentence / proper Case or Upper Case. This tutorial is also applicable to Microsoft Excel. Many people know how to change the text for in Documents but not in spreadsheets. Hope this Spreadsheet tutorial will be useful for many of you.
Sign in to your Google Drive account to use Google Doc Spreadsheet. There under “Create” you can see “Spreadsheet”. Open a spreadsheet and just read and apply the points A, B, & C below. You can first apply it on any spreadsheet to get the result. It will change the text form, but you will get the result in a new cell. For example the text in Cell C6 can get in Cell D6 or any other cell (see the screenshot). It is because we are using functions to convert text form in Google Doc Spreadsheet. We can change it later. You can apply the upper, lower or sentence case on the same cell where the original text is. For that just head to the last paragraph of this tutorial.
A. How to Change Text to Upper Case in Google Doc Spreadsheet
On any blank cell of your spreadsheet apply the following function without quotes.
Replace the word “text” with cell address of the text to be made upper case.
B. How to Change Text to Lower Case in Google Doc Spreadsheet
Apply the function below as instructed above.
C. How to Change Text to Sentence Case in Google Doc Spreadsheet
Apply the below function as mentioned in “A”
Of course it changed the upper case to lower case or lower case to upper case like wise. But the result is in a new cell. You want to change the case of letters in the same cell where the text is. To that copy the formula and paste it in the same cell where the original text is. But don’t just paste. You have to right click on the cell and go to Paste Special->Paste Values only. After that you can erase the formula.
Watch the below video tutorial for any clarification.
About Article Author
Learn how to create a chart in Google Doc Spreadsheet. It’s so simple that any one without any prior knowledge
We can create unit calculators using Google Doc spreadsheet for our day to day spreadsheet purpose. It can ease our
Earlier we have posted a complete tutorial about creating line chart in Google Doc Spreadsheet. Now in this post we
It is very simple to convert a Google Doc Spreadsheet to Excel or PDF file format. Still we write this
Earlier we have learned how to create a Line Graph or Line Chart using Google Doc Spreadsheet. In this Google
Google Doc Spreadsheet has lots of similar Excel functions to fulfill users data entry needs. Here is one useful tips for