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

Last modified: 23 May 2021