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

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment