How to Change Capital Letters to Lowercase in Excel

How to Change Capital Letters to Lowercase in Excel

Today we’ll be talking about how to change capital letters to lowercase in Excel and we’ll even deal with cells containing mixed upper- and lower-case letters.

Ready to start?

Would you rather watch this tutorial? Click the play button below!

How to Change Capital Letters to Lowercase in Excel

If you’d like to change capital letters in a cell to lower case, click on the cell to select it first.

Then type in the equal sign and start typing out the function ‘LOWER’.

How to Change Capital Letters to Lowercase in Excel - typing out the function ‘LOWER’

Click on the suggestion and carry on by defining the cell that contains the text you’d like to convert into lower case. Here it is the text in the cell B3, so we’ll click on B3, close the brackets.

How to Change Capital Letters to Lowercase in Excel - defining the cell that contains the text
How to Change Capital Letters to Lowercase in Excel - close the brackets

Press Enter and here we go – all lower case now!

How to Change Capital Letters to Lowercase in Excel - all lower case text

If needed, you can copy the function through drag and drop to the rest of the rows and change the capital letters into lowercase for all the data.

How to Change Capital Letters to Lowercase in Excel - copy the function through drag and drop

Now, if you change anything in the source cell, the change will be reflected in the converted text.

How to Change Capital Letters to Lowercase in Excel - if you change anything in the source cell, the change will be reflected in the converted text

This happens because we used a function to convert the text into lowercase, which we can see if we click into the cell C3.

How to Change Capital Letters to Lowercase in Excel - we used a function to convert the text into lowercase

But what if we need to store only the values, the converted texts themselves, and we don’t want to keep the function in the data table? Well, that’s easy to do.

How to Store Only the Values in the Cell

Let’s select the converted data and use the control key [Ctrl] and C to copy the contents of the cells.

How to Change Capital Letters to Lowercase in Excel - use the control key [Ctrl] and C to copy the contents

Now, we use ‘Paste’ here at the top to simply paste them in the same place, but we need to go for the option ‘Values’.

How to Change Capital Letters to Lowercase in Excel - select option ‘Values’

Through this we make sure that all the cells contain the converted text only.

How to Change Capital Letters to Lowercase in Excel - the cells contain the converted text only

Don’t miss out a great opportunity to learn:

If you found this tutorial helpful, give us a like and watch other tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers!

Thanks for watching and I’ll see you in the next tutorial!

Comments

Add comment

Your email address will not be published.

Your personal information will only be used for the purpose of processing this comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.