Free Online Tutorials on Spreadsheets

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 - 2019 | All Rights Reserved