Function: LOWER

by | Nov 12, 2018 | Excel Formulas

Function: LOWER

The LOWER function converts a text to lowercase. In this guide, we’re going to show you how to use the this function and also go over some tips and error handling methods.

Supported versions

  • All Excel versions

Syntax

LOWER(text)

Arguments

text

The text you want converted into lowercase.


Examples

Example 1

=LOWER(“Charizard”)
formula returns “charizard” as text value.

LOWER Example 1

Example 2

=LOWER(Id&” – “&Name&” – “&Type)
formula returns “6 – charizard – fire, flying“. The LOWER function can convert strings from references. It doesn’t affect numbers, spaces, or punctuation.

LOWER Example 2

Download Workbook

Tips

  • Try UPPER function to convert strings into uppercase.
  • Try PROPER function to capitalize the first letter of each word in a text.