Description:
Convert all characters of a string to lower case.
Syntax:
lower(s)
Note:
The function converts all characters of a string to lower case.
Parameter:
|
s |
The string you want to convert to lower case. |
Option:
|
@q |
A quoted string won’t be converted. |
Return value:
A string
Example:
|
lower("ABCdef") |
abcdef |
|
lower("defABC") |
defabc |
|
lower@q("\'AD\'") |
'AD' |
|
lower("\'AD\'") |
'ad' |
|
|
A |
|
|
1 |
"ABC" |
|
|
2 |
=lower@q(A1) |
"ABC" |
Related function: