LOWER Function

About

LOWER function in Excel is used to convert capital letters into small letters.

Function Type

Text

Purpose

Convert text into lower case.

Return value

Lower case version of the text

Syntax

=LOWER(text)

Arguments

text – text string to be converted into lower case


Example


Notes

LOWER function ignores numbers.


Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)


New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel