

- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Similar to UPPER( ) and LOWER( ), PROPER( ) would take a text string as an argument, and convert it to โProper Caseโ, where the first letter of every work is upper-case, and subsequent letters in the word are lower-case.
EXAMPLE:
PROPER ( โ1232 DEER VALLLEY AVEโ ) would return: 1232 Deer Valley Ave
USE CASE: I use AirTable in my real-estate business, where I hire virtual-assistants to enter public property data scraped from county websites (which often stores data in upper-case). That address data is used to for mail-merge to marketing letters, but unless I take abother step to convert the data to Capital case, the merged data appears ALL UPPERCASE, which makes the letter seem auto-generated.
To solve this, my workflow includes an export from AirTable out to a .csv file, then into Excel where I run a macro that converts to Proper Case, and then is imported back into AirTable, then out to our document merge partner (WebMerge).
Iโd love to eliminate that last, fussy part of the workflow where I export out just to convert the text. If I have a PROPER ( ) function as described, it would greatly simplify my AirTable/WebMerge workflow.
Thanks!