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 8 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?
Website Copyright Laws for Online Business

If you are starting a business and are working to build and promote it, there are some important things to […]

Wave Video for Social Media Video Marketing

Social media video marketing is the hottest trend and the most effective marketing tool. It helps reach masses of the […]

How Good UX is Designing A Better Future For Online Shopping

Why so many consumers prefer shopping online in 2020? The obvious answer is ‘coronavirus’, but it’s not as simple as […]

How to Start a Successful Online Business

Creating an online business is an exciting endeavour, but it can feel a little overwhelming if you are unfamiliar with […]

5 Benefits of Professional Commercial Cleaning Service

People spend a lot of their time at workplaces, which is why it is essential to keep the workplaces clean […]

5 Tips on Creating Marketing Videos on a Budget

Video marketing is the way forward. Businesses that are failing to leverage the power of video marketing are falling behind […]

Five Essential Law Firm Website Requirements

Five Essential Law Firm Website Requirements The best law firm website is one that lets you accomplish the key purpose […]

Leave a Reply

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

chevron-downmenu-circlecross-circle