How to Change Text Case in MS Excel

Quick summary

This tutorial shows how to change text case in Microsoft Excel using built-in functions like LOWER, allowing you to quickly convert cell values to lowercase without manual retyping. Excel's text case formulas let you apply changes across multiple cells at once by dragging the fill handle to extend the formula.

Steps

1. Open the file you want to edit in Microsoft Excel.
2. Click on the target cell where you want the converted text to appear, type an equals sign followed by LOWER, then select the source cell — for example, =LOWER(A3).
3. Click the bottom corner of the cell and drag to highlight the remaining cells containing the names or words you want to convert.
4. Confirm that all selected entries are now displayed in lowercase as expected.