How to Change Case in Microsoft Excel: 1-Min Guide

How to Change Case in Microsoft Excel

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to change text case in Microsoft Excel using formulas.

Quick summary

Microsoft Excel does not have a built-in button to change text case, but you can use the UPPER, LOWER, and PROPER functions to convert text instantly. This step-by-step guide shows you how to apply these Excel text functions to any cell range in your spreadsheet.

Steps

Open the Excel file you wish to edit in Microsoft Excel.
Select a target cell and type =UPPER to begin the formula.
Add an open parenthesis, click on the source cell containing the text, then close the parenthesis.
Press Enter, then drag the fill handle (the small square at the bottom-right corner of the cell) to apply the formula to additional cells.
Follow the same steps using =LOWER or =PROPER to convert text to lowercase or proper case as needed.

📌 Why this matters

Changing text case in Microsoft Excel is a common data-cleaning task that helps ensure consistency across spreadsheets, reports, and imported datasets. Excel's built-in text functions — UPPER, LOWER, and PROPER — let users convert text to the correct case in seconds without manual retyping. Mastering these formulas saves significant time when standardizing names, addresses, or any text-heavy data. This skill is essential for anyone working with large datasets, data entry workflows, or preparing Excel files for further analysis or reporting.

Your product deserves an interactive demo

Start free

How to Organize Dates by Week in Excel

How to Make Cells Fit Text Microsoft Excel

How to Make a Bar Graph in Microsoft Excel