How To Use Excel LOWER Function – A Quick Guide

Posted on by Sharath Raju

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…

Published by Sharath Raju

I am an engineer by profession and by heart :) It's been 7+ years since I have been working with software development and robotic process automation. I have implemented close to 80+ RPA processes in total by using Uipath. It is so true that someone learns more by not reading something but by practicing the skill. I have been trying to understand exactly where people who are just starting out their career struggle and understand the pain of struggling for hours trying to figure something out.I can help you with that. Having a passion to share my piece of content, I have created step-by-step easy-to-digest courses. My goal is to help you get ready for the future by learning new talents and becoming more productive by providing you with relevant and useful courses. I'm still learning and exploring my field of work :) Every feedback should be as valuable as you are to me, please feel free to reach out to me if you have any feedback, questions, or need any help.Thank You...

Leave a Reply

%d bloggers like this: