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 11 months ago on April 1st, 2020.

Related To:


Up to 35% OFF AliDropship Plugin

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?
Easy Tips to Maintain Your WordPress Site

We love WordPress. It's the leading CMS for creating websites. Here are some Easy Tips to Maintain Your WordPress Site

COVID-19 and E-Learning Trends

The COVID-19 pandemic took the world by surprise, and what is even more surprising is that it's 2021 and the […]

5 Easiest Ways to Create Your Ecommerce Website

You can make an ecommerce website for a brick or a packet of tablets. But what is important is how […]

Proven Tips How to Improve Your Content Strategy with Influencer Marketing

One of the best ways to improve your content marketing is with influencer marketing strategy. This will help you reach […]

How to Increase Brand Awareness with Digital Content Marketing

The digital world is more powerful than ever – and its power keeps growing. If you want to survive in […]

Why is Ethical Leadership Important in Business

How many times have we come across peer pressure and do ethically wrong things? Or Like probably favor a candidate […]

The Importance of Having a Website for Business

If you are running a business without a website, it means you are skipping the step of success. In this […]

Leave a Reply

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

menu-circlecross-circle