Manuals/calci/LOWER1
Jump to navigation
Jump to search
'
LOWER(text)
where text- is the text that converted into lowercase.
Calci converts all uppercase letters into lowercase letters.
LOWER ignores the characters in text that are not letters.
LOWER
Lets see an example in (Column2,Row1)
=LOWER(B2)
LOWER returns smith.
Consider another example
=LOWER("Zcubes")
LOWER converted Zcubes into zcubes.
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | SMITH | smith | 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 |