Whether you operate as a small business or an international company, reaching out to potential customers worldwide is always a […]
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.
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.
Related Tutorials on Google Sheets using Power Tools:
With the increase in the use of smartphones all around the world, businesses nowadays are finding new ways to connect […]
The advance of technology has made it easy to work with different teams across different geographic locations. A ship manufacturer […]
The automotive industry is changing substantially as the time passes and the technological innovations are the reason behind this change. […]
In business, if you want to reap success, it’s important to look at past stories of successful entrepreneurs. This article […]
Do you know that customers are the lifeblood of business? And without them, a business cannot survive? According to a […]
Some websites can contain a very large amount of data, such as companies contacts, product details and prices, images, stats, […]