How to use LOWER Function in Excel

Posted on: June 5, 2022 in Excel Functions , 9.8 K
blog img

Description:

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.

Goal

Converts all uppercase letters to lowercase.

Syntax


=LOWER(text)

Arguments

TEXT – Required.


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

Examples


=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 XLOOKUP with Multiple Criteria in Excel

    While Excel’s XLOOKUP function does not natively support multiple criteria…

  1. How to Use XLOOKUP in Excel

    XLOOKUP is a versatile function in Excel used for performing…

  1. How to use AVERAGE Function in Excel.

    This function calculates the average from a list of numbers.…

  1. How to use ADDRESS Function in Excel

    The ADDRESS function to obtain the address of a cell…

  1. How to use ACOSH function in excel

    The ACOSH function returns the inverse hyperbolic cosine of a…

Popular post

  1. Eclipse IDE – Create New Java Project.

    Opening the New Java Project…

  1. How to start the project in android studio

    Android Studio Open the Android…

  1. How to use ACOSH function in excel

    The ACOSH function returns the…

  1. Complete Header tags in html – easy to learn

    H tags can be used…

  1. Best features in Python programme – easy to learn

    Python is the most widely…