Skip to main content

LOWER

 

Definition

Converts a specified string to lowercase.

Sample Usage

LOWER("LOREM IPSUM")

LOWER(A2)

Syntax

LOWER(text)

  • text - The string to convert to lowercase.

See Also

UPPER: Converts a specified string to uppercase.

PROPER: Capitalizes each word in a specified string.

In order to use the LOWER formula, start with your edited Excellentable:

Then type in the LOWER formula in the area you would like to display the outcome:

By adding the values you would like to calculate the LOWER formula for, Excellentable will generate the outcome:

 

A
B
1
Data
2
 STRING 1
3
 STRING 2
4
 STRING 3
5
 STRING 4
6
 STRING 5
7
8
 string 2

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.