I received an export of user data and the names were all over the place; some all lower case, some all upper, some a mixed bag. I needed a way to take the names and standardize them all to be Proper Case so messaging looks good.
While Excel has the proper() function, Coda has upper() and lower() but nothing similar. I created the tool below to help you solve this problem!
This is amazing! Thank you for sharing! However I have a little issue - lots of the names in my list have a middle name - is there any chance you could help in adapting this so that it can accomodate for middle names!?
In the doc in the second comment in this post there is a column called [Name Split Proper Case] that might be what you want. I’ve also added three separate columns: [First Name], [Middle (Second) Name] and [Last Name].
Here we take the FullName and convert it to lowercase. Then we split each name (based on space) into multiple names. Then, for each of those names, we replace the first character with an uppercase version of the same character.
Finally, we join all the names back together with a space between each name.