** The LOWER function in Excel is a text function used to convert all uppercase letters in a text string to lowercase. It is very useful when you want to change case UPPER To LOWER or we can say that it is useful when we want to change our data from capital tatters to small letters. The case of text data or when you need to perform case-insensitive comparisons or analysis.We cane change over data upper case to lower case in a single command. Here's the syntax for the LOWER function:
=LOWER(text)
text: This is the text or cell reference that contains the text you want to convert to lowercase.
For example, if you have the following text in cell A1:
HELLO WORLD
Type as given blow image:
=LOWER(A1)
The result will be: as given in image
hello world
The LOWER function does not modify the original text; instead, it returns a new text string in lowercase. You can use this function in various ways in Excel to manipulate and format text data as needed. **
Put Comment for quarry