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?
How to Optimize Marketing Content to Get Hits Among International Customers

Whether you operate as a small business or an international company, reaching out to potential customers worldwide is always a […]

How Mobile Apps Can Help In Optimizing Business Growth

With the increase in the use of smartphones all around the world, businesses nowadays are finding new ways to connect […]

10 Greatest Challenges the Virtual Teams are Facing Now

The advance of technology has made it easy to work with different teams across different geographic locations. A ship manufacturer […]

Emerging Trends & Technologies in the Automobile Sector

The automotive industry is changing substantially as the time passes and the technological innovations are the reason behind this change. […]

5 Famous Entrepreneurs & Their Way to Success

 In business, if you want to reap success, it’s important to look at past stories of successful entrepreneurs. This article […]

5 Effective Customer Engagement Strategies

Do you know that customers are the lifeblood of business? And without them, a business cannot survive?  According to a […]

Extract Data From Any Website with RTILA

Some websites can contain a very large amount of data, such as companies contacts, product details and prices, images, stats, […]

Leave a Reply

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

menu-circlecross-circle