Text Function | How to use the Excel LOWER Function?

1 minute, 20 seconds Read

In the previous post, we saw ‘Text Function | How to use the Excel PROPER Function?‘, now we will learn about ‘How to use the Excel LOWER Function?’.

Where to Find the Text Function?

To find the text function in excel open excel and click on the “Blank” to open a blank excel worksheet now click on the ‘Formula Tab’ and under ‘Function Library’ click on the ‘Text’ option as shown below:

excel lower function

You can also see the text function via shortcut key – press ‘ALT + M + T’ after that select the text function that you want to use.


What is Excel LOWER Function?

The Excel LOWER function Converts all uppercase letters in a text string to lowercase. It ignores space, numbers, and punctuation.


Syntax

LOWER(text)

Converts all uppercase letters in a text string to lowercase.


Arguments

The LOWER function syntax has the following arguments:

Text: Required. The text you want to convert to lowercase. LOWER does not change characters in text that are not letters.


Understand With Example

lower function excel

In this way, you can convert text into lower case. In the above example, you can see that we used cell reference of the text like C4 instead of that you can use the formula in this way =LOWER(“RAM”) the output will be ram.

Converts all uppercase letters in a text string to lowercase. It ignores space, numbers, and punctuation.

In the next post we will explore about the excel ‘UPPER’ function with the help of example.


For Latest Updates & Learning Join Our YouTube Channel: Join Now

author

EduTaxTuber Team

We are here to help for every updates related to everything...👍📙👍📗

Similar Posts

Leave a Reply

England vs Senegal: FIFA World Cup 2022 No Curfew in Mumbai: Section 144 Imposed to ensure Peace Elon Musk suspends Kanye West Twitter Account for inciting violence Pak Vs England: England vs Pakistan FIFA World Cup 2022: CBDT Notifies Income Tax Exemption
Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock