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!
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’.
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.
Press Enter and here we go – all lower case now!
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.
Now, 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.
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.
Let’s select the converted data and use the control key [Ctrl] and C to copy the contents of the cells.
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’.
Through this we make sure that all 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!