LOWER

Formulas / LOWER
Convert text to lower case.
=LOWER(text)
  • text - the text to lowercase

Examples

  • =LOWER("Apple")

    The LOWER function is used to convert any text string to all lowercase. For example, this returns "apples".

  • =LOWER("APPLE")

    The LOWER function is not case-sensitive, so the same result is returned when the same string is inputted in uppercase. For example, this returns "apples" as well.

  • =LOWER(A1)

    The LOWER function can also be used on cell references. For example, this which contains the number "44373" will return "44373".

  • =LOWER(A1)

    The LOWER function is not case-sensitive, so the same result is returned when the same cell reference is inputted in uppercase. For example, this will still return "44373".

Summary

The LOWER function is used to convert all letters in a text string to lowercase without changing non-character letters.

  • The LOWER function converts text to lowercase letters, with the argument being either a text value or a cell reference.


Frequently Asked Questions

What is the LOWER function?
The LOWER function is a string function that converts all letters in a text string to lowercase.
Does the LOWER function change text that is not a text string?
No, the LOWER function does not change text that is not a text string.
What are some common uses of the LOWER function?
The LOWER function is often used to:
  • Standardize the case of text
  • Make text easier to read
  • Simplify searches and comparisons
When should I not use the LOWER function?
The LOWER function should not be used when you need to maintain the original case of the text.
Sourcetable Logo

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code.

Drop CSV