Change case in Google Sheets

Change case in your Google Sheets in 5 ways: Capitalize Each Word, UPPERCASE, lowercase, tOGGLE, Sentence case. Сhange Case is part of Power Tools – get it at Google Sheets store:
https://workspace.google.com/marketplace/app/power_tools/1058867473888

Visit the help page for Change Case:
https://www.ablebits.com/docs/google-sheets-replace-text/#change-case

Learn more about Power Tools and its other 30+ add-ons on our website:
https://www.ablebits.com/google-sheets-add-ons/power-tools/index.php

00:04 Introduction to Change Case
00:57 Start the add-on
01:24 tOGGLE TEXT
01:38 UPPER CASE
01:46 lower case
01:52 Capitalize Each Word
02:06 Sentence case.
02:31 Wrap-up

👋 Let's be friends on socials!
LinkedIn: https://linkedin.com/company/apps4gs/
Facebook: https://www.facebook.com/ablebits/

#changecase #googlesheets #spreadsheet #ablebits

---

Closed Caption:

Change case for Google Sheets is a formula-free
solution to
capitalize and lower letters in spreadsheets in 5 different ways.
Whether your cells contain single words or
entire sentences,
this tool will quickly change case in your Google Sheets.
It will:
1) convert all uppercase letters into lowercase and vice versa at the same time
2) capitalize every single letter so the entire text is in uppercase
3) turn everything to lowercase
4) make only the first character of a cell
capital
5) or capitalize the first letter of all words
No matter the option, it takes only a couple
of mouse-clicks to get there.
Let me show you what I mean directly in spreadsheets.
I have a table of randomly generated customers
and their orders.
The 'Product' column has only text
while 'Addresses'
has both text and numbers.
So let's run Power Tools.
You can change the case right from this 'Quick
actions' menu,
but I'd like to show you the add-on itself.
I start Power Tools,
open the 'Text' group > 'Modify' tool,
and get to the 'Change case' right away.
There are 5 options, and the way they're written
also hints at how they change case.
Let me just select the columns where I want
to change the text case, and we'll go through the options.
I don't have formulas
so I don't select this setting,
and choose to toggle the text first.
See? All letters in my selection have been reverted:
upper into lower and lower into upper.
The next one is 'Uppercase'.
Once I run it, it capitalizes all words
and all letters within the selection.
In a similar manner, I can lower every single
letter using the 'lowercase' option.
If I want to capitalize
only the first letter in all words,
I choose the respective setting:
'Capitalize Each Word'.
If you keep this checkbox empty,
the Change case add-on
will also lower all other letters.
Last but not least is the 'Sentence case'.
It capitalizes only the very first letter in each cell.
I run it and it looks like nothing happens.
But in fact, it simply doesn't lower
other letters –
they are kept intact
in case there are names or abbreviations.
To lower them anyway,
I need to lower everything first –
and then apply the 'Sentence case'.
And that's it!
That's how the Change case add-on
processes your entire table in a matter of seconds.
Install Power Tools
from the Google Sheets store
and master changing cases on your own.
Should you have any questions,
please don't hesitate and contact us,
we'll be happy to help.