Manuals/calci/UPPER1
Jump to navigation
Jump to search
'
UPPER(text)
where text- is the text that converted into uppercase.
Calci converts all lowercase letters into uppercase letters.
UPPER ignores the characters in text that are not letters.
UPPER
Lets see an example in (Column2,Row1)
=UPPER(B2)
UPPER returns JOHN.
Consider another example
=UPPER("Zcubes")
UPPER converted Zcubes into ZCUBES.
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | john | JOHN | 4 | 5 |
| Row2 | 7 | 8 | 9 | 128 |
| Row3 | 12 | 67968 | 14 | 15 |
| Row4 | 17 | 18 | 10000 | 20 |
| Row5 | 36 | 67994 | 10027 | 168 |
| Row6 | NaN | 0.8509 | 1.6198 | 0.5253 |