1. Home

Excel LOWER Function

The LOWER function is used to lowercase text in a cell

LOWER Function

The LOWER function is used to lowercase text in a cell.

Changing the letter case of your cell values can be great when there is a lot of case inconsistency among the cell inputs or when preparing your dataset for case-sensitive usage.

It is typed =LOWER

If you want to use the function on a single cell, write:

=LOWER(cell)

If you want to use the function on a range of cells, write:

=LOWER(start cell:end cell)

A is uppercase.

a is lowercase.

How to Use LOWER Function

To lower the text within an Excel cell, use LOWER.

Step 1) Start the LOWER function
  • Select a cell E2
  • Type =LOWER
  • Double click the LOWER command
    • Follow along the tutorial by trying it yourself!

    Copy the values in the example above and try it on your own!

    Step 2) Define the cell
  • Select a cell (A2)
  • Hit enter

    • The letter case of cell A2 has been changed!

    Step 3) Define the range to use the LOWER function on multiple cells
  • Select the starting cell (A2)
  • Add a colon (:)
  • Select the ending cell (B21)
  • Hit enter

    • function copyFormulas(elementId){ /* Get the text field */ var copyText = document.getElementById(elementId); /* Select the text field */ copyText.select(); copyText.setSelectionRange(0, 99999); /* For mobile devices */ /* Copy the text inside the text field */ navigator.clipboard.writeText(copyText.value) .then(() => { alert('Range copied to clipboard.\nIt can now be pasted into the Excel spreadsheet.') }) .catch((error) => { alert(`Copy failed! ${error}`) }) }

    Categories

    HTML CSS3 Bootstrap Foundation Sass JavaScript TypeScript JQuery AngularJS React NodeJS Highcharts PHP Python Python3 Django Linux Docker Ruby Java C C ++ Perl Servlet JSP Lua Scala Go ASP C # SQL MySQL SQLite MongoDB Redis Android Swift ionic Kotlin XML tutorial

    Contact US