Close the Skill Gap -> Enroll to be a Certified Financial Modeling & Valuation Analyst (FMVA)® Today!

LOWER Function

Returns the lowercase version of the given text string

What is the LOWER Function?

The LOWER function is categorized under TEXT functions. The function will return the lowercase version of the text string given. It was introduced in MS Excel 2000 version and is available in all subsequent Excel versions.

In financial modeling, LOWER can be useful in arranging data or creating data in a certain format. For example, we can create an email address from the names available in a data set.

 

Formula

=LOWER(text)

 

Th LOWER function uses one argument, that is, text. It is a required argument here. It is the text that we wish to convert to lowercase. The function will not change the characters in the text string that are not letters. So, for example, numbers and punctuations will remain unaffected when we use LOWER.

 

How to use the LOWER Function in Excel?

As a worksheet function, the LOWER function can be entered as part of a formula in a cell of a worksheet. To understand the uses of the function, let us consider a few examples:

 

Example 1

Suppose we imported data from an external source and wish to convert them in lowercase.

  • Text
  • TEXT34
  • Text


The results in Excel are given in the screenshot below:

 

LOWER Function

 

Example 2

Suppose we are given the first name and last name in the data set. If we wish to build email addresses using first and last names, we can use a formula that will concatenate the values. It can be done using the LOWER function. The data given are shown below:

 

LOWER Function - Example 2

 

We want the email ids to be [email protected]

The formula to use will be:

 

LOWER Function - Example 2a

 

We will get the results below:

 

LOWER Function - Example 2b

 

If we want only the first letter from the first name, we can use the LEFT function. In the above formula, the first name is joined to the last name using the concatenation operator (&), and the result is wrapped in the LOWER function, which forces all text to lower case.

Finally, the result we get is joined again to “@” and then to the domain. The domain is kept separate for convenience only.

 

Click here to download the sample Excel file

 

Additional resources

Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional resources:

  • Excel Functions for Finance
  • Advanced Excel Formulas Course
  • Advanced Excel Formulas You Must Know
  • Excel Shortcuts for PC and Mac

Free Excel Tutorial

To master the art of Excel, check out CFI’s FREE Excel Crash Course, which teaches you how to become an Excel power user.  Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.

 

Launch CFI’s Free Excel Course now to take your career to the next level and move up the ladder!