How to convert all uppercase letter in to lowercase letters in Excel | Use of LOWER Function (Formula) in Excel

LOWER

Use of LOWER Function / Formula in Excel

This formula converts all uppercase letters in particular cell into lowercase letters.

Syntax/Formula of LOWER Function in Excel

The syntax of LOWER function in Microsoft Excel is below.


=LOWER(text)

Example of LOWER Function in Excel

Step 1: First Type ADVANCEDMSEXCEL.BLOGSPOT.COM in cell B4 as per shown in below image.

Step 2: Type formula =LOWER(B4) in cell B6 and press enter.

LOWER FUNCTION