PIT Designs Logo

How to Easily Change Text Case in Google Sheets

About the author: Ninos
I'm the owner and founder of PIT Designs. I love creating digital presence and creative digital solutions for our clients.


Posted 2 months ago on April 1st, 2020.

Related To:


We all love Google Sheets, it's the best alternative to Microsoft Excel and does the job for most cases. However, When you inherite a spreadsheet that is not properly managed or formatted. You may end up with some spaces in cells, text case not matching or unformatted.

Here's an easy way to change text case in Google Sheets.

blank

How to change text case in Google Sheets, using Power Tools.

Get Power Tools Extension

Google-Sheets-Power-Tools

Download Google Sheets Power Tools from here. (it's Free)

Select Cells Containing the Text

blank

Select the cells that contain the text you with to change the text case for.

Run Text Modification Feature

Capitalize-Each-Word-Google-Sheets

Now go to Add-Ons > Power Tools > Text > Modify.
Select Change Case. and Run.
In this example I'm using Capitalize Each Word.
Other options are available such as, UPPER CASE, lower case, tOoGglE TeXt, and Sentence case.


Related Tutorials on Google Sheets using Power Tools:

How to Split Cells in Google Sheets (2 Steps)

5/5 (1 Review)
All the Shape Dividers in Oxygen Builder
blank

Shape Dividers in Oxygen builder is the new cool feature added. Shape dividers have become more and more used in […]

Revealing Footer in Oxygen (CSS Only)
blank

Revealing footer of a website is a nice effect, we used it on our Web design for startups page. The […]

Working During (Coronavirus) COVID-19 in Erbil
blank

The recent pandemic COVID-19 also known as Coronavirus, has hit us all around the world. No doubt it's not the […]

Should You Hide Your Quora Questions?
blank

In this new article, we are talking about Quora and more specifically if it is a good idea to hide […]

Awesome Update Google Adds Chrome Group Tabs
blank

Google Chrome released update version 81 with a cool new feature. That has been requested for ages. Chrome Group Tabs! […]

Talking Sopranos a Podcast from the Wise Guys
blank

Talking Sopranos is the new podcast on the internet. Everybody is talking about it. It's of course from the wise […]

Scroll Progress Bar Indicator in Oxygen
blank

Beautify your blog posts with scroll progress bar indicator. Oxygen Builder/WordPress using simple CSS and JS only.

Leave a Reply

Your email address will not be published. Required fields are marked *

For security, use of Google's reCAPTCHA service is required which is subject to the Google Privacy Policy and Terms of Use.

I agree to these terms.

chevron-downmenu-circlecross-circle