Converts a given string to lowercase.

Along with Upper and Proper, this is useful for bypassing case-sensitivity in other Text functions.

Usage

Lower(text)

text (required) A string or column where each row contains a string.

Example

Lower("PLEASE KEEP QUIET IN THE LIBRARY")

  • Returns “please keep quiet in the library”

Related resources