LOWER Function in Excel
Table of Content:
LOWER Function in Excel
In Excel, the LOWER
function is used to convert all uppercase letters in a text string to lowercase.
Here's the syntax of the LOWER
function:
=LOWER(text)
where text
is the text string you want to convert to lowercase.
For example, if you have a cell with the text "HELLO WORLD", you can use the LOWER
function to convert it to lowercase like this:
- Select the cell where you want to display the lowercase text.
- Type the
LOWER
formula:=LOWER(A1)
- Press Enter.
The cell will now display the text as "hello world".
Note that the LOWER
function doesn't change the original text in the cell, it only returns a new text string with all uppercase letters converted to lowercase. If you want to replace the original text with the lowercase version, you'll need to copy and paste the new text into the cell.