Skip to main content

LOWER function


LOWER Function converts all uppercase letters in a text string to lowercase.

If you want to converts all lowercase letters in a text string to uppercase, please use UPPER function




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


The example may be easier to understand if you copy the example data (include header) in the following table, and paste it in cell A1 of a new Excel worksheet. If you need to, you can adjust the column widths to see all the data.

Data Formula Result Description
Excel Bible =LOWER(A2) excel bible Lower case of text string.
ExcelBaby =LOWER(A3) excelbaby Lower case of text string.
Excel 2019 =LOWER(A4) excel 2019 Lower case of text string.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>