Lower
Converts all uppercase letters in a text string to lowercase.
Syntax
LOWER(value)
The LOWER function syntax has the following arguments:
- value (Required) The text you want to convert to lowercase. LOWER does not change characters in text that are not letters.
Example
Field 1: E. E. Cummings
Field 2: Apt. 2B
| Formula | Description | Result |
|---|---|---|
| =LOWER([Field 1]) | Lower case of first string (e. e. cummings) | e. e. cummings |
| =LOWER([Field 2]) | Lower case of last string (apt. 2b) | apt. 2b |
Updated almost 2 years ago