How to use visual elements to tell a story Let's start with an interesting fact that will amaze you. Do […]
I'm the owner and founder of PIT Designs. I love creating digital presence and creative digital solutions for our clients.
Posted
3 years ago on April 1st, 2020.
Related To:
Tags: Google Sheets
The Ultimate Guide to Choosing a Great Domain Name for Your Business
Choosing the right domain name for your business is a critical step in building a strong online presence. Your domain […]
6 Mistakes to Avoid When Creating a React-Native App
React Native is a leading cross-platform app development framework that has more than one and half thousand active contributors. The […]
Will Elon Musk Turn Twitter into a Super-App?
Elon Musk envisions a future where mobile apps are consolidated into one-stop shops within a single platform. Will he create a "super app" to rule them all in 2023? Learn about the challenges he faces and the potential impact on companies like Twitter and Apple's App Store.
8 Steps to Start Your Shirt Printing Business like a Pro
The custom design market is rising daily, and its demand is relatively easy to fulfil if you have the right […]
What Is Out-Of-Home Advertising - Types & Strategies
OOH, or out-of-home advertising has been around for a long and is still one of the best ways to contact […]
Best Tools That Make Content Readability Better
These three best tools can enhance content readability: 1) Paraphrasetool.ai 2) Word-counter.io 3) Hemingway Editor. Use these tools and achieve perfection in your work.
How to Lock Entire WordPress Website for the Public Without Plugins
You can lock your entire WordPress website and make it only visible to logged-in users without using a plugin by adding a simple code.
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.
Table of Contents
Get Power Tools Extension
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
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.
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.