Hey there stranger!

Sign up to get access.

Capitalize Each Word

About this Tutorial

Every word can be capitalized with this formula.

Featured Formulas

Video Transcript

 Hello. Here's one more really incredibly useful thing to do in Google Sheets that you might not know. We're actually gonna do three things, and one of them is probably something you may not know. What we're gonna do, we're gonna capitalize each word. We're gonna capitalize new words or lowercase.

We're gonna capitalize all the letters, which is uppercase. So you may know the uppercase and lowercase, but you may not know how to capitalize each word because it is literally because it just is a different name in Google Sheets than anywhere else I've ever been able to find. Why we're gonna be capitalizing different words, different letters.

There's a few reasons. Article titles. If you are writing a newsletter like I am, I have a lot of different article titles that I capture over the course of a week, and when I put them into my newsletter, I want to reformat them to be standard. So using this Formula, very simple formula. It saves me like an hour a week from capitalizing or each individual letter of an article title.

You can uppercase winner's names if you're doing like some kind of ranking system and you wanna make sure that you know the, the, the winner knows they're a winner. You can uppercase them when your. , when you use lowercase, you might wanna make something easier to read or you may want to make it like a subtitle.

Oh, uppercase and small letters as well, or text for font. It makes a great subtitle where you may wanna bold it or may wanna present that text in a different light. But you might wanna uppercase it and make it smaller. Make it like a subtitle, a lowercase might be easier to read depending on the font.

So there's a lot of reasons. , and here's how you do it. So you may take a word like uppercase and in another cell you literally use the formula equals upper. So we can do this, we can actually do it on here equals U P P E R, and then just put the E cell. And now we have all caps or capitalized. If we wanna do lowercase, we do equals lower L o w e r.

And we put the text there.  and now everything is lowercase. Now title case or capitalizing in each word is the unique one, and it's called Proper. Proper. And each letter at the beginning of each word is capitalized For some reason, this is not called title or title case where it's uppercase, lowercase.

Proper case is not a term that I've been able to find online.  and here's some other uses of it like this. You want to capitalize this? I, but like maybe there's some other texts there. So you go proper. Say again what it looks like and this

This is really useful. Capitalize a bunch of'em with a bunch of words. Were not capitalized and we can do uppercase here.

One more bonus use of this is when you are searching for words. So a lot of times I'll use, I'll make a little search bar in a Google sheet. Maybe if we have a database of articles or a database of key words, I'll make a search. , and I'll type in a word, but I don't know what the capitalization people will use.

So if you take whatever input they do and lower it and make sure all of the articles are titles or whatever database you're doing is also lowercase, then you will never have a problem using query design or fine. Where there's some kind of capitalization errors that really is super useful.

If you want to learn how to make searchable databases or searchable parts of your Google Sheets, check out better sheets.co right now, giving away 30 $30 all access. I will never charge you again if you're watching this a year from now and it's more than $30. I. Truly am. Sorry you didn't get to know about it earlier.

But check out better sheets.co. There's al still more free tutorials for you to go through@bettersheets.co. Check it out and we can learn how to do search bars. We can l learn how to do databases, how to get that data into your, your sheet. All great. Deep, deep tutorials. I go through projects. I show you how to do it step by step.

Please join Better sheets.co.