HomeMicrosoft OfficeExcelLOWER function in Excel

LOWER function in Excel

The LOWER function in Excel converts the uppercase text to low. This post describes the working and the syntax of the LOWER function in Excel.

LOWER function

Converting an uppercase text to a lowercase text in Excel is possible with the LOWER function option. This function converts the uppercase text to lower case without troubling the numbers and space given in between the text. It accepts only the Text argument or the cell reference.

Syntax

=LOWER(Text)

How to use LOWER function in Excel?

  1. Type the text in uppercase, and place the cursor on the cell where you need to replace and display the text in uppercase.
How to use LOWER function in Excel?

2. Type the syntax and hit the enter key.

How to use LOWER function in Excel?

3. The uppercase text will be converted to lowercase text. Use the auto-fill option to convert the remaining text.

How to use LOWER function in Excel?

This how the LOWER function in Excel work. Hope this post provided all the information about the working of the LOWER function in Excel.

Leave a Reply

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021