How to Change The First Letter to Lowercase in Microsoft Excel

Date:2021-7-21 Author:Sandra

In the last tutorial, we use the PROPER formula to capitalize the first letter in Excel. But how to change uppercase to lowercase?—that’s the Lower formula.

Let’s take the same table as an example, and change the case into the yellow cells.

How to Change The First Letter to Lowercase in Microsoft Excel

Now, we type LOWER() in cell I1 and press Enter key. Then hit Ok.

How to Change The First Letter to Lowercase in Microsoft Excel

After you hit Ok, click on cell E1. A blue box will appear, and press Enter key.

How to Change The First Letter to Lowercase in Microsoft Excel

This LOWER formula converts the word in cell E1 from uppercase to lowercase in cell I1.

When the cursor becomes a black solid plus in the lower right corner of cell E1, click and fill down.

How to Change The First Letter to Lowercase in Microsoft Excel

That’s the end of the tutorial, now you can change text cases in Excel according to your needs.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

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