GOOGLE SHEETS HAS A PROPER PROBLEM
PROPER() has a problem. The Google sheets native formula PROPER() adds capital letters after apostrophes.
Creating Custom Title Case Functions in Google Sheets with Apps Script
In this video, learn how to create a custom title case function in Google Sheets using Apps Script. Discover the limitations of the built-in 'proper' function and see how to enhance it to correctly capitalize the first letter of each word while handling apostrophes properly. Follow along as the speaker demonstrates the step-by-step process of writing and implementing this custom function, allowing you to rename it as desired for flexibility.
00:00 Introduction to Capitalizing Text
00:08 Understanding Title Case vs. Proper Case
00:57 Creating a Custom Function in Google Sheets
02:11 Implementing the Custom Function
02:45 Customizing and Renaming Functions
03:50 Conclusion and Additional Tips
