Excel Lower Function
In Excel, the LOWER function converts text to lowercase. Here's the basic syntax:
=LOWER(text)
text : This is the text string from which you want to extract characters.
For example, if you have the text "Hello" in cell A1 and you want to convert it to lowercase, you would use:
Lower Formula used in B3
This formula will return "hello". It converts all the uppercase letters in cell A1 to lowercase.
You can use the LOWER function in various scenarios, such as when you want to standardize text inputs or when you need to perform case-insensitive comparisons.
Advertisement