How to use LOWER Function in Excel
Description:
Excel Lower Function Converts all uppercase letters in a text string. This function does not effect numbers, punctuation and spaces. There is no difference in the result when Excel cell string text is already in lowercase.
Goal
Converts all uppercase letters to lowercase.
Syntax
=LOWER(text)
Arguments
TEXT – Required.
TEXT - This is the text we want to convert to lowercase.
Examples
=LOWER(B10) // returns 44715
Cell B10 contains the date value, but lower function eliminates the date formatting and will returns the date serial number.
=LOWER(B11) // returns 25000
If the numeric value is assigned to the lower function, the lower function eliminates the number formatting.
Related post
-
![](https://techsiter.com/wp-content/uploads/2021/07/av1.png")
How to use AVERAGE Function in Excel.This function calculates…
-
![](https://techsiter.com/wp-content/uploads/2021/04/address.png")
How to use ADDRESS Function in ExcelThe ADDRESS function…
-
![](https://techsiter.com/wp-content/uploads/2021/04/acosh.png")
How to use ACOSH function in excelThe ACOSH function…
-
![](https://techsiter.com/wp-content/uploads/2021/04/acot.jpg")
How to use ACOT function in excelThe Excel ACOT…
-
![](https://techsiter.com/wp-content/uploads/2021/04/acos.jpg")
How to use ACOS function in excelThis function is…
Popular post
-
![](https://techsiter.com/wp-content/uploads/2021/03/java.png")
Eclipse IDE – Create New Java Project.Opening the New…
-
![](https://techsiter.com/wp-content/uploads/2021/03/and.jpg")
Start the project in android studioAndroid Studio Open…
-
How to use ACOSH function in excel
The ACOSH function…
-
![](https://techsiter.com/wp-content/uploads/2021/04/my.jpg")
How to learn HTML – Header tag in htmlH tags can…
-
![](https://techsiter.com/wp-content/uploads/2021/04/ap.jpg")
Python program – best featuresPython is the…