Microsoft Excel offers a very interesting way to convert uppercase to lowercase. We can cater to this problem statement by using the “=LOWER()” formula. We can perform the below mentioned way to convert uppercase to lowercase in excel:
We’ll learn about this methodology step by step.
To do this yourself, please follow the steps described below;
Step 1 – Excel sheet with an uppercase text in a cell
– Open the desired Excel workbook containing an uppercase value in a cell
Step 2 – Apply the formula
– Now apply the formula “=LOWER(“ and then reference the cell where the uppercase text is present, and then hit Enter.
Step 3 – Lowercase text obtained
– We can see that the uppercase text has been changed to lowercase.