Worst Formula in Google Sheets #spreadsheetmagic
In this video, discover why the PROPER formula in Google Sheets is considered the worst due to its misnaming and a bug that affects capitalization after apostrophes. Learn about a solution that addresses this issue with a custom add-on for title case formatting.
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
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. Add Title Case to Google Sheets How to Customize PROPER Function in Google Sheets (Creating a Headline Case) Advanced Coding Tips in Google Sheets for Programmers