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

Related To:


pCloud Lifetime 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?
Types of Insurance You Need to Protect Your Business

Running a business in 2021 is one of the riskiest things in the world! With all the restrictions and uncertainties […]

4 Solutions for Alternative Investment Firms

Alternative investments have increasingly become accessible to investors. Therefore, knowing about them is essential for industry professionals and investors. It […]

Promote Your Way to Profits in 5 Ways

Are you operating a business that seems like it's stuck in the summer doldrums? If earnings, sales, and profits aren't […]

Modern & Effective Strategies to Boost Your Business

There are multiple operations in a business that you have to check out thoroughly for the smooth running of a […]

Why Is HTTPS Important and How to Add It Easily for Free to Your Website?

In August 2014, Google created ripples in the webmaster community by stating that its algorithms would henceforth treat HTTPS as […]

How to Get the Best Legal Translation Help in Business

Different people around the world understand only their native language. It would become difficult for them to communicate with people […]

Using SalesBlink To Automate Cold Outreach

SalesBlink is an all-in-one cold outreach platform. But this isn't just another tool for email marketing. SalesBlink helps you automate […]

Leave a Reply

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

menu-circlecross-circle