Excel Lower Function

This post will guide you how to use Excel LOWER function with syntax and examples in Microsoft excel.

Description

The Excel LOWER function converts all characters in a text string to lowercase.

The LOWER function is a build-in function in Microsoft Excel and it is categorized as a Text Function.

The LOWER function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.

Syntax

The syntax of the LOWER function is as below:

= LOWER  (text)

Where the LOWER function arguments are:
text -This is a required argument. The text string that you want to convert to lowercase.

Example

The below examples will show you how to use Excel LOWER Text function to convert all uppercase characters in a text string to lowercase.

#1 To lower case all characters in B1 cell, just using the following formula:=LOWER(B1).

excel lower function example1


More Related LOWER Function Examples

  • Change Uppercase and Lowercase Text
    if you want to change all text string in uppercase into lowercase, you can create a formula based on the Lower function. And if you want to convert all letters in one cell into uppercase, you can use the Upper function as a formula in excel.…
Related Posts

How to Convert Uppercase to Lowercase Except the First Letter in Excel
Convert Uppercase to Lowercase 4

In excel, words can be entered in uppercase, lowercase or mixed. If we want to convert all uppercase to lowercase (except the first letter in some situations), we can use formula with some letter convert related functions to convert them ...

How To Force Text String to Upper,Lower, or Proper Case in Excel
force text string to upper lower proper7

This post will guide you how to force test strings to uppercase or lowercase or Proper cases through an Excel formula or data validation in your Excel 2013/2016. How to convert text to upper, lower, or proper case in Excel. ...

How to Remove Middle Name from Full Name in Excel
Remove Middle Name from Full Name 6

When we get a list of full names, we can remove the middle name for short in some cases. As the middle names are different among the full name list so we cannot replace them by space directly in excel. ...

How to Check If a Cell is Uppercase, Lowercases or Capitalize in Excel
check letters uppercase2

This post will guide you how to check if a cell is uppercase in Excel 2013/2016. How do I identify all letters in cells are lowercases or capitalize in Excel. How to change letters to uppercase, lowercases or capitalize first ...

Change Uppercase and Lowercase Text
change uppercase to lower3

This post will guide you how to change the case of text to uppercase or lowercase in Excel. How do I change all uppercase text to lower case with an Excel formula. For example, if you want to change all ...

Split Text and Numbers in Excel
Split Text and Numbers in Excel4

This post explains how to split text and numbers in excel, or how to extract the text characters from another strings with text and numbers combined. Split Text and Numbers If you want to split text and numbers, you can ...

Split Text String by Line Break in Excel
Split Text String by Line Break in Excel2

In the previous post, we talked that how to split text string by a specified character in excel. And this post will guide you how to split text string by Line Break character. The difference is that you can type ...

The difference between Replace function and Substitute function in Excel
The difference between Replace function and Substitute function1

There are two similar functions to replace text string in Excel. They are REPLACE and SUBSTITUTE functions. What’s the difference between REPLACE function and SUBSTITUTE function in excel 2013?  This post will introduce the difference between those two function in ...

Excel Replace Function Remove Text String
Excel Replace Function Remove Text String1

This post will teach you how to remove a text string of specified length from another text string in a cell. Excel Replace Function Remove Text String If you want to remove text string from a cell in excel, you ...

Combining the REPLACE Function with FIND Function to Remove Text in Excel
Combining the Replace function with Text function 2

How to remove a text string or characters from a cell when the text is at a specific position. And this post will guide you how to remove a text string from a cell or column that the removed text ...

Sidebar