Advertising for home services, such as lawn care, home cleaning, and garden maintenance, isn’t as simple as tossing up an […]
I'm the owner and founder of PIT Designs. I love creating digital presence and creative digital solutions for our clients.
Posted
6 years ago on April 1st, 2020.
Related To:
Tags: Google Sheets
How applicant tracking systems are revolutionizing remote recruitment
Gone are the days of traditional recruitment. Applicant tracking systems have been revolutionizing how we hire, and their impact is here to stay. But how is the change happening? Tap to learn more about it.
Check out the New AI Features in FlexClip 5.0
In today's digital era, the importance of video content cannot be overstated. Videos have become an integral part of various […]
Effective Cleaning Tips for Maintaining a Clean and Healthy Home
We’ll explore some practical tips and tricks that will help you establish an effective cleaning routine. You might not realize […]
The Art of Visual Storytelling
How to use visual elements to tell a story Let's start with an interesting fact that will amaze you. Do […]
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.
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.