Explainry Tutorials to Expert in IT

LOWER function in Excel


LOWER function is used to get all text strings with lower case letters, ignoring numbers and punctuation formats.



Where text is a cell reference in which you want all lower case letters.


To get following text strings in lower case letters, do these steps:

1. Select cell B1, type =LOWER(select A1 cell) and press Enter.


2. Copy the formula from cell B1 and paste it in cell B2 (or simply go to cell B2 and press Ctrl + D).

Note: In column B, numbers and punctuation are unchanged.

Copyright © 2016 - 2020 Explainry.com | All Rights Reserved