Is this the Worst Formula in Google Sheets?

0:00 What's the worst formula in Google Sheets? I have the perfect answer. The worst formula in Google Sheets is called proper. And the reason why it is the worst formula is because it's misnamed and it actually has a bug in it. What you have is you have uppercase, lowercase, sentence case, and you should have title case . But Google Sheets doesn't have a formula for title case . Title case is that every single word in a string is going to be capitalized. What we do have in Google Sheets is proper and what it does is it capitalizes the first letter of every word in a string. However, it has a bug. That bug is that if you add an apostrophe, it will also capitalize the letter after that apostrophe. So simple Add Title Case to Google Sheets How Do I Capitalize Each Word in Google Sheets? Add Title Case to Google Sheets Capitalize all words or no words in #GoogleSheets

0:47 questions like what's this? What's that? When's this? How's that done? You know what? Nobody knows why it is. But I have actually made a add-on that fixes this. It's called better formulas. You can get it at bettersheets.co/addons. That fixes it. It calls it title case and it fixes that apostrophe capital issue. You're watching better sheets here on YouTube. Watch this video or this video. It's going to make your Google Sheets better. Go ahead, ask me anything down below in the comments and I'm going to answer it in a future video. Become a member of better Sheets today. You get videos, you get sheets. So, what do I have to do to get you into a brand new Google Sheet? Go buy some tools that I've built inside of Google Add Title Case to Google Sheets What's Inside Better Sheets? Better Sheets Videos Checklist Button Styles

1:32 Sheets. Doing things in Google Sheets you never thought possible. Go check it out. Hacks You Might Not Know When did you learn the secrets of Google Sheets? | Sheet Talking Episode 8 Esa Introducing SheetFools SheetOps