LOWER()
Syntax. LOWER(text)
Definition. This function converts a string to lowercase.
Arguments
text (required). The text you want to convert to lowercase
Background. The LOWER() function is the counterpart of the UPPER() function that converts a string to uppercase. All uppercase letters are converted to lowercase letters. All other characters are left unchanged.
You can also use this function to compare non–case-sensitive strings.
If you pass a numeric value in the text argument, this value is converted to unformatted text. If you refer to this text in numeric calculations, Excel converts the text back to a number value so that you can still use the result for other calculations.
If you want to compare text and are not concerned about the comparison ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
