In this tutorial, you will learn how to change the text to all caps in Google Sheets.
How To Change Text To All Caps In Google Sheets
Do you need to quickly change a text to all caps?
For example, suppose you have a list of names and you need to convert all these names into uppercase. It can be a hassle to retype everything yourself.Fortunately, Google Sheets has a built-in function that can help you with this.
In this guide, we will show you how to use the UPPER function to convert all of your text to all caps in Google Sheets.
How to Capitalize All Letters in a Text in Google Sheets
Here’s our step-by-step guide on how to capitalize all letters in a text in Google Sheets.
First, select the cell where you want to output the target string in all caps.
Begin typing the UPPER function.
The UPPER function requires a single argument. It can be a string or a cell reference to a string. The function converts all lowercase letters to its uppercase equivalent.
In our example above, we were able to convert the string “Hello World” to “HELLO WORLD”
We’ll use the AutoFill tool to convert the rest of our text values into all-caps text.
Another way to convert all letter to uppercase is by performing the conversion in Google Docs.
Start by copying the cell or cell range you want to convert to all-caps.
In a new Google Docs document, paste the text values.
Use your cursor to select the values again.
In the Format menu, select Text > Capitalization > UPPERCASE.
The selected text should now be converted to all-caps.
You can now copy and paste the new strings back into your Google Sheets spreadsheet.
This guide should be everything you need to learn to change texl to all caps in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.
More ways to use text in Google Sheets:
- Add Bullet Points
- Insert Text Box
- Insert Special Characters
- Insert Symbols
- Insert Page Break
- Center Text
- How To Make Text Fit In Cell
- Make Text Vertical
- Change Case
- View Page Breaks
- Line Break In Google Sheets
- How To Capitalize
- How To Wrap Text
- How To Indent
- Count Cells with Text
- Fit Text to Cell
- Checking if a Cell Contains a Substring
- TEXT Function
- Combine Text From Two Cells
- SUMIF Cells If Contains Text
- Add Text To Formula
- Indent Text
- Spell Check in Google Sheets
- How to Use Spell Check
- Insert a Bullet List
- Make a Numbered List
- Insert Bullet Points
- Add a New Line In Cell
- Add Multiple Lines In One Cell
- Wrap Text In Cell
- Superscript In Google Sheets
- Make A Degree Symbol
- SUBSTITUTE Function
- How To Alphabetize