Calc LOWER function

For a full list of available calculation functions, please read What calculation functions are supported.

This article describes the formula syntax and usage of the LOWER function.

Description

Converts all uppercase letters in a text string to lowercase.

Syntax

LOWER(text)

• text - Required. The text you want to convert to lowercase. LOWER does not change characters in text that are not letters.

Example

Formula	Description	Result
=LOWER({variable})	Returns all lower case of variable (assuming the variable is "TOTAL")	total
=LOWER(yiELD)	Returns all lower case of text	yield

Errors

For a full list of formula errors, please read Formula errors.

Related functions

• Calc CHAR function
• Calc CLEAN function
• Calc CODE function
• Calc CONCAT function
• Calc DETECTLANGUAGE function