Function reference
Sets the first letter of each word in a string to a capital letter and all other letters to lowercase (for example, ROBERT E. LEE would be Robert E. Lee).
WordCap ( string )
| Argument | Description |
| string | A string or expression that evaluates to a string that you want to display with initial capital letters (for example, Monday Morning) |
Data type: String
Returns string with the first letter of each word set to uppercase and the remaining letters lowercase.
Example 1
This expression returns Boston, Massachusetts:
WordCap(‘boston, MASSACHUSETTS’