How to change text case in ms excel
- George Apostolov
How to change text case in ms excel: step-by-step guide
Open the file you want to edit.
Click on the cell where you want the changes to be applied, type an equals sign followed by the word 'LOWER', and then select the cell of choice. For example,
=LOWER(A3).Click the bottom corner of the cell and drag to highlight the rest of the names or words you wish to modify.
As you can see the names are now all in lower case.
Quick answer: To change text case in Excel, open your file, enter the formula with the desired cell in a new cell, and drag the corner to apply the changes to other words.
About this Excel tutorial
Modify text case quickly in Excel by entering a formula and dragging the fill handle across your spreadsheet data. This guide shows how to change text case in ms excel in 4 steps, starting with "Open the file you want to edit" and finishing with "As you can see the names are now all in lower case". The interactive demo above is a click-through copy of the real Excel interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to change text case in ms excel?
4 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Excel data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Excel. Related guides: How to Change the Data Series Name in Microsoft Excel, How to Change the Font Size in Microsoft Excel and How to Change the Legend Text of Microsoft Excel Charts. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
