How to use LOWER Function in Excel

blog img


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.


Converts all uppercase letters to lowercase.




TEXT – Required.

TEXT - This is the text we want to convert to lowercase.


=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.

Share your thoughts

Your email address will not be published. All fields are required.

Related post

  1. How to use AVERAGE Function in Excel.

    This function calculates…

  1. How to use ADDRESS Function in Excel

    The ADDRESS function…

  1. How to use ACOSH function in excel

    The ACOSH function…

  1. How to use ACOT function in excel

    The Excel ACOT…

  1. How to use ACOS function in excel

    This function is…