June 13, 2021

How to use the Excel LOWER function

The LOWER function is categorized under Excel TEXT functions. The function will return the lowercase version of the text string given. It was introduced in MS Excel 2000 version and is available in all subsequent Excel versions.

Syntax: =LOWER (text)

The LOWER function syntax has the following arguments:

  • Text (Required) The text you want to convert to lowercase. LOWER does not change characters in text that are not letters.

Example: Let’s look at some Excel LOWER function examples and explore how to use the LOWER function as a worksheet function in Microsoft Excel:

Excel LOWER function - How to use the Excel LOWER function

Syntax:  =LOWER(A11)


Excel LOWER function 1 - How to use the Excel LOWER function

Syntax: =LOWER(A12)
Result: meilani raina

Syntax: =LOWER(A13)
Result: amayah lailah

Syntax: =LOWER(A14)
Result: rayne zaniyah

Syntax: =LOWER(A15)
Result: isabela nathalie

READ:  How to use max function in excel

Leave a Reply

Your email address will not be published. Required fields are marked *