Capitalizes the string passed to the function. Only the first character is converted to upper case and the rest remain the same
= CAPITALIZE(value)
value |
A string which is to be capitalized. The value can be specified as a decimal value (e.g., 37.48), as a string (“Word”), or as the value of a variable (e.g, FirstName). |
String
In the case of an error, the function displays an error message: “CAPITALIZE(value): Error message”
The function can be used in combination with other functions.
Example |
Returns |
= CAPITALIZE(“test”) |
“Test” |
= CAPITALIZE(“iron speed designer”) |
“Iron speed designer” |
= CAPITALIZE(Product) |
The capitalized version of the value of the value of Product. |
= UPPER(FirstName) |
The capitalized version of the value of the values of FirstName. |
= CAPITALIZE(RIGHT(“iron speed designer”, 8)) |
A capitalized version of the extracted string. |
= CAPITALIZE(CONCATENATE(“iron “, “speed “, “designer”)) |
A capitalized version of the concatenated string. |
= CAPITALIZE(“iron speed”). INSERT(10, “ designer”) |
A capitalized version of the string obtained after insertion. |