In this tutorial, you will learn how to change case in Google Sheets.
When you’re working in Google Sheets, you may find you need to change the case of certain text. For example, you might want to change to all caps to draw attention to a section header. Before you take the time to retype the text in the desired case, read the following instructions to learn how to change case using Google Sheets formulas
The function to change text to all uppercase is UPPER(). Here’s how to use it:
Select a cell to display the uppercase text and type the following formula: “=UPPER(A2)” where A2 is the cell containing the text to change
You can also type the text directly into the formula surrounded by quote marks: “=UPPER(“text to change”)”
The function to change to lowercase is LOWER(). Use it in the same way as the UPPER() function describe above
Proper case is when the first letter of each word is capitalized and all other letters are lowercase. It is often used for headings and labels.
The function to change text to proper case is PROPER() and it works the same as the UPPER and LOWER functions.
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to change case in Google Sheets. Want more? Check out all the Google Sheets Tutorials.