How To Use Excel LOWER Function –A Quick Guide

Sometimes we might want to convert the text to LOWER case irrespective of whatever case it has been entered as.

Excel LOWER function can be used to achieve the same.

Let’s see how to use it in detail…

1. What is the LOWER Function?
2. What is the Syntax?
3. How to use it with an example?

1. What is the LOWER Function?

An LOWER function can be used to convert the given text into lower case, ignoring numbers and punctuations.


2. What is the Syntax?

=LOWER(text)

  • text  = (Required) Text that we want to convert to lower case.

Note :

  • Any numbers or punctuations available in the text are ignored

3. How to use it with an example?

Suppose we have to convert some existing data to the LOWER case

let’s see how to do that…!!!

Excel LOWER function 1

**Explained**

=LOWER(B1)
  • B1 = Reference to the cell ,which we want to convert to LOWER case.

 

Hope it has helped you… 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: