LOWER Function in Excel


Home >> How to Use Excel Tutorial >> Excel Formulas List >> LOWER Function in Excel



In this tutorial, you will learn all the things about the LOWER excel formula. LOWER function in excel is useful to make all the letters in data to become non-capital.


Why do We Need to Learn LOWER Excel Formula?


In processing data on a spreadsheet, sometimes we want to make all the letters in a text to non-capital. This is needed for various things, such as modify the look of a document template for the formulation of a particular document that we want to use or maybe change the content from a group of data because we want to use the changed results version from the data for a specific purpose such as the process input of a formula.

As a simple example of the need in our work, let’s say we are creating an invitation letter document from a template that our company provides. In the company’s template, maybe all of the content use capital letters. We want to make all of them to non-capital before editing them to make it appropriate with our need in the letter document. But, of course, it will be very troublesome if we have to do it one by one to all of the content in the template.

To help you in making all of them to non-capital automatically as the need in the case example, then you can use the LOWER excel formula. LOWER function in excel will help you to make every letter in a data or text becomes non-capital. Useful for you to learn if you often deal with text data in a spreadsheet.


What is LOWER Function in Excel?


LOWER function in excel is a function with the usage objective to change all of the letters in data to non-capital. This function will not give any effect to parts of the data other than the capital letters.

Generally, this function input can be explained briefly as follows:


=LOWER(text)


Note:
text = the data which letters want to be processed


How to Use LOWER Excel Formula?


The following will explain the writing of the LOWER excel formula. This formula is easy to use because it only needs one input which is the data that you want to change all the letters inside into non-capital.


Using LOWER Function in Excel

  1. Type equal sign ( = ) in the cell where you want to put the result in

    LOWER Function in Excel - Screenshot of Step 1

  2. Type LOWER (can be with large and small letters) and open bracket sign after =

    LOWER Function in Excel - Screenshot of Step 2

  3. Input the data or cell coordinate where the data which you want to process is after the open bracket sign. If you want to type a text data in this manually without using a cell coordinate, then do not forget to type the text between two quotes signs (“”)

    LOWER Function in Excel - Screenshot of Step 3

  4. Type close bracket sign

    LOWER Function in Excel - Screenshot of Step 4

  5. Press Enter
  6. The process is done!

    LOWER Function in Excel - Screenshot of Step 6



Exercise


After learning how to use the LOWER excel formula, now is the time to deepen your understanding by doing the following exercise.

Download the exercise file and do all of the instructions. Download the answer key file if you have done them and want to check your answers or if you are confused about how to do the instructions.

Link of the exercise file:
Download here

Instructions

Do the following three instructions by putting the answers on the gray-colored cells in the appropriate row according to the number! Use the LOWER excel formula to do all the instructions!
  1. Change the letters from the name on the left to non-capital!
  2. Change the letters from the product code on the left to non-capital!
  3. Write your name with capital letters as the input to change them into non-capital!

Link of the answer key file:
Download here


Additional Note


If you want the opposite, change all the letters into capital, then you can use the UPPER function. The writing of it is very similar to this LOWER function in excel.



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


Hand-Picked CE Tutorials

Excel Calculation

How to Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division Excel Calculation

Average Excel Calculation



Excel Formula

VLOOKUP Excel Formula

Excel IF Function

SUM Formula in Excel

COUNTIF Formula in Excel

COUNT Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text Excel

Excel Worksheet Definition

Excel Range Definition

How to Add Columns in Excel



Excel Consultation

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2021 Compute Expert