Skip to content
Home » Google » How to Capitalize Text in Google Sheets

How to Capitalize Text in Google Sheets

Capitalize Your Text in Google Sheets

Sometimes you need your text in capital letters (or all lowercase). If your information is in a spreadsheet you can use formulas to make your text in uppercase (or lowercase).

=UPPER()

In a spreadsheet cell type =UPPER( and click on the cell that contains text that you want in uppercase. Press enter. =UPPER(A1) will express what is in A1 to uppercase.
Upper or lower

=LOWER()

=LOWER() works the same way! =LOWER(A1) expresses the content in A1 as lowercase.

Paste Special

The problem with using a formula for =UPPER() or =LOWER() is that you now have the information in your spreadsheet twice. Highlight the new values. Use Control C to copy. Immediately use Control Shift V to paste special overtop of where the formulas are. This will strip the formulas and leave only your capitalized text. You can now delete the original non capitalized text.

Paste Special Control Shift V for Google Sheets: Capitalize Text

Try it Yourself

Here is a sample spreadsheet so you can give it a go.

Want More Help with This? Become a Premium Member

Google Docs Google Play App Store Install

If you use Google Docs you want to be sure to have the mobile version as well. Use google play app store install

Navigate Google Forms Sections

If you use Google Forms you want to be using SECTIONS in Google Forms and controlling how students navigate the Form.. Navigate Google Forms Sections

BETTER – Print Google Form Quiz

Have more control over how your Google Form™ Quiz prints. Sometimes you need your Google Form on paper and this solution will help you to do it better! Print Google Form Quiz to a Google Doc and custo…

Something Fun for the End of the Year

What is something fun for students to do at the end of the year? While there are many choices, a fun word search can give students something to do while other students are finishing a task. Try my tem…

Collaborate with Students – reuse TemplateTab

Reuse TemplateTab to collaborate with students and have less paperwork to grade.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.