LOWER

Purpose

  • Makes all characters in a text string lowercase

Example

LOWER

  • Here is a screenshot, for reference:

LOWER


Syntax

  • =LOWER(text)

Arguments

  • text
    • This is the text that you want to make all lowercase
    • This can be hard-coded text, a cell reference, or text resulting from a calculation

Tips

  • This can be handy when creating unique identifiers (to make everything consistent)

External Links