PIT Designs Logo

How to Easily Change Text Case in Google Sheets

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


Posted 6 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.

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

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)
Do we all agree that Coffee is the fuel that feeds the free content creating?
6 Ultimate Content Marketing Writing Techniques to Boost Audience Rate

Are you seeking the best ways to improve your content creation? Are you excited to master your marketing development strategy? […]

How to Choose Professional Fonts for Web Design

Fortunately, the days when fonts and colors were chosen at random have long passed. Now each element of the site […]

How to Write Design Brief for Web Design Projects

Got a big web design project coming up? Then you'll need a great design brief for web design, to carry […]

Adobe CC Updates Focused on Collaboration & Remote Work

Adobe's June updates to its Creative Cloud suite comes with changes directly aimed at making collaboration and remote-work better and […]

6 Ways Erbil International Hotel Complies with COVID-19 Safety

Erbil International Hotel, have activated the "Health and Safety program" which ensures customers, from the moment they enter the property until leaving.

Starting Online Business in Iraq

As part of our business launching & partnership programs. We help you kick start your project online, and start making […]

Drawing Anatomy & Art: A Place for Artistic Freedom

Art, in its broadest sense, is a form of communication. It's been known and shown throughout history how mankind used […]

Leave a Reply

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

chevron-downmenu-circlecross-circle