How to use the LOWER Function in Excel
Description
The LOWER Function is categorized as Text Function in Excel. This function converts all given text strings to lowercase.It do not affect the punctuation, spaces, special characters and the text string which are already in lowercase. But it will convert number as text and it will remove all number format.
The LOWER function takes one argument which can be a text string or any cell reference. It can also be used as a part of a formula. We can use this formula to organize large volume of text.
Syntax
The syntax of LOWER function is =LOWER(text)
Argument or Parameter
text- can be a text string or cell reference which we want it to be in lowercase text.
Returns
The LOWER returns text strings in lowercase from a given text string.
Examples
Example-1
We have provided different types data which contains text having text string in uppercase, lowercase. Numbers with different number format. We have also added punctuation and special character. All the data are in A column and we lower function is used column B, we can see the results in column B. See the image below.
Example-2
Suppose we have imported external data in column A and column B. We can see the data in column is unorganized, different text are in different type case and we need to convert it into lowercase. So what we have to do is, select cell C2 and type =LOWER(B2 ) and press Enter. Then drag the fill handle of cell C2 till the last cell of the data. All the data will be converted to lower case at a time.
Example-3
Suppose we have a data which contains the first name and last name of employees in capital letter, and we need to create email address of each employee with company's domain which is abc.com. Now we will understand how to use lowercase as part of formula.
In the above image we can see in Column B & C contains employee's first name & last name in capital letter. And in column D we converted it to email address with help of LOWER function. In Column E we can the formula of column D. =LOWER(B2&C2)&"@abc.com".
Notes
- All uppercase text will be converted to lowercase text.
- Lowercase text will remain unaffected.
- Formatting of standalone numeric value will be removed.
- Lower case function can used as a part of formula.
********************************* ~:Support Our Work Financially:~ *********************************
Project File Type: Free
If you think this tutorial helps you to solve your problem and add value to your work, Buy me a Coffee..
************************************************************************************************
|
|
||||
|
CHAR |
CLEAN |
CONCATENATE |
||
|
DOLLAR |
EXACT |
FIND |
FIXED |
LEFT |
|
LEN |
MID |
NUMBERVALUE |
||
|
REPLACE |
REPT |
RIGHT |
SEARCH |
SUBSTITUTE |
|
T |
TEXT |
TRIM |
UNICHAR |
UNICODE |
|
UPPER |
VALUE |
|
|
|
0 Comments