Converts all the characters in the string to uppercase.
= UPPER(value)
value |
A string which is to be converted to uppercase. 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: “UPPER(value): Error message”
Example |
Returns |
= TRIM(“ Iron Speed Designer “) |
“Iron Speed Designer” |
= UPPER(“TEST”) |
“TEST” |
= UPPER(“Iron Speed Designer”) |
“IRON SPEED DESIGNER” |
= UPPER(Product) |
The upper case converted version of the value of Product. |
= UPPER(FirstName) |
The upper case converted version of the value of FirstName. |
= UPPER(RIGHT(“Iron Speed Designer”, 8)) |
The upper case version of the extracted string. |
= UPPER(CONCATENATE(“Iron”, “Speed”, Designer”)) |
An uppercase version of the concatenated string. |
= UPPER(“iron speed”). INSERT(10, “ DESIGNER”) |
A upper case string concatenated with the string supplied to the insert function. |