Exciting news!
You can now get 2 google sheets functions that are fixed!

I'm releasing Better Formulas. A Google Sheets Add-on that fixes two bugs inside of Google Sheets native functions.

What do you get?

TITLECASE() fixes the fact that PROPER() capitalizes letters after an apostrophe. It will still capitalize the letter at the start of each word.

CHECKEMAIL() fixes the fact that ISEMAIL() which only checks a limited set of TLDs. I've added every known TLD to this add-on function as of May 2024.

How much does it cost?

It's free.

How can I do this?

If you're a Better Sheets member you can take this course, for free: How to Create a Google Sheets Add-on​

And if you're not a member you can purchase the course separately on Udemy: How to Create a Google Sheets Add-on​

for the next 4 days that link offers a Best Price discount.

The course goes through the entire process step-by-step. So you can publish an add-on available to 2 billion Google Sheets users.

But it does not do much to show you how to code.

For that you'll want to take "Master Spreadsheet Automation" on Udemy, or "Spreadsheet Automation 101" on Better Sheets

-Andrew

Your Resident Google Sheets Wizard at BetterSheets.co​