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!
When you click on the Share button in the doc, can you use the “Embed” option and paste that code in? That might force that one section. You can also hide the sections menu on the left if you want.
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!?
Hi @Ben_Swanson
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].
For clarity Firstname is the column. The formula converts the string to lowercase, then replaces the first character, with an uppercase version is the first character!
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.