In Excel, the LOWER function takes a text string and converts it to all lowercase letters. This can be useful for sorting data or for creating text labels with all lowercase letters. The syntax for the LOWER function is:
where text is the text string that you want to convert to lowercase letters.
The syntax of the LOWER function in Excel is LOWER(text). This function takes a text string as an input and returns a lowercase version of the text.
One way to use the LOWER function in Excel is to convert text to all lowercase letters. For example, if you have a list of first names that are all uppercase, you can use the LOWER function to convert them to lowercase. This can be helpful when you want to alphabetize a list of names or when you want to compare two lists of text and want them to be treated as if they are all the same case.
There are many instances in which you should not use LOWER in Excel. For example, if you are trying to compare two text strings and want to return a result that reflects which string is greater, you should use the Excel function GREATER than LOWER. Additionally, if you are working with text that includes both uppercase and lowercase letters, using LOWER will convert all letters to lowercase, which may not be what you want.
Formula Result =LOWER(text) Converts text to lowercase =LOWERB(text) Converts text to lowercase and ignores spaces =LOWERC(text) Converts text to lowercase with accents =LOWERD(text) Converts text to lowercase with diacritics =LOWERF(text) Converts text to lowercase with accents and diacritics