How to Change Text Case in Excel (Uppercase, Lowercase & Title Case)

You have a spreadsheet full of names, and half of them are typed in the wrong case: “ali ahmed” in one row, “SARA KHAN” in the next, “mary-kate o’brien” in the one after. Fixing them by hand would take forever — and retyping invites typos.

Excel has three built-in functions that change text case for you in seconds: UPPER, LOWER and PROPER. This guide shows you exactly how each one works, with one worked example per function.

The Three Case Functions in Excel

Excel’s case tools are simple formulas you type into a cell. Each one takes a piece of text and returns it in a different case:

Function	What it does	Example
`UPPER`	Makes every letter uppercase	`UPPER("hello world")` → “HELLO WORLD”
`LOWER`	Makes every letter lowercase	`LOWER("HELLO WORLD")` → “hello world”
`PROPER`	Capitalises the first letter of every word	`PROPER("hello world")` → “Hello World”

They never change the original cell — the result appears where you typed the formula, so your source data stays safe.

UPPER: Change Text to All Capitals

The UPPER function turns every letter into a capital letter. It is the one to use when a form or a system wants everything in capitals.

The formula: =UPPER(A2) — where A2 is the cell holding the text.

Worked example. Suppose cell A2 holds ali ahmed. Type =UPPER(A2) in cell B2, and the result is:

ALI AHMED

Two more checks: UPPER("mcdonald") gives MCDONALD, and UPPER("hello world") gives HELLO WORLD.

When to use it: headings, codes, ID numbers, and anywhere a system asks for capitals.

LOWER: Change Text to All Lowercase

The LOWER function does the opposite: every capital letter becomes small. It is the fix for text that arrived in SHOUTING CAPITALS.

The formula: =LOWER(A2)

Worked example. Suppose cell A2 holds SARA KHAN. Type =LOWER(A2) in cell B2, and the result is:

sara khan

Two more checks: LOWER("HELLO WORLD") gives hello world, and LOWER("McDONALD") gives mcdonald.

When to use it: cleaning up imported data and email addresses, and any list where capitals crept in by accident. If you only need to fix capitals in normal writing rather than a spreadsheet, our guide on how to change uppercase to lowercase covers the same job in plain text.

PROPER: Change Text to Title Case

The PROPER function capitalises the first letter of every word and makes the rest lowercase. It is the one to use for names and titles.

The formula: =PROPER(A2)

Worked example. Suppose cell A2 holds ali ahmed. Type =PROPER(A2) in cell B2, and the result is:

Ali Ahmed

PROPER is smarter than it looks: it treats any character that is not a letter as a word boundary, so it also capitalises after hyphens and apostrophes. Two checks:

PROPER("mary-kate o'brien") gives Mary-Kate O'Brien — both parts of the hyphenated name and the letter after the apostrophe are capitalised.
PROPER("john smith, jr.") gives John Smith, Jr. — the word after the comma is capitalised too.

When to use it: name lists, addresses, book and article titles, and any column that should read like proper English.

The Full Workflow: Fix a Whole Column in 4 Steps

For a column of names in the wrong case — say column A holds 200 names and you want them in title case:

Step 1: Add a helper column. In cell B2, type =PROPER(A2).

Step 2: Fill it down. Double-click the small square at the bottom-right corner of B2, and Excel copies the formula down the whole column — one formula per name.

Step 3: Turn the formulas into plain text. Select the whole helper column, copy it, then right-click and choose Paste Special → Values. This replaces the formulas with the actual text, so the results stay correct even if you delete column A.

Step 4: Replace the original column. Delete column A, and the helper column becomes your clean list.

The same four steps work with UPPER and LOWER — just swap the function in step 1.

Faster Alternatives for Big Lists

Formulas are the reliable method, but two faster options exist:

Flash Fill (Ctrl+E). Type the corrected version of the first two or three names in the next column — for example, type Ali Ahmed next to ali ahmed and Sara Khan next to SARA KHAN — then press Ctrl+E. Excel spots the pattern and fills the rest.

Common Mistakes and Traps

1. PROPER breaks acronyms. PROPER("NASA") gives Nasa, not NASA. PROPER capitalises the first letter and lowers the rest, so it ruins any word that is meant to be all capitals. If your list has acronyms (NASA, BBC, USA), fix those by hand afterwards, or use UPPER on those rows.

2. PROPER is not true title case. A style guide leaves small words lowercase in the middle of a title — “The Lord of the Rings”, not “The Lord Of The Rings”. PROPER capitalises every word, including “of”, “and” and “the”. For book titles and headings that follow a style guide, you will need to adjust the small words by hand.

3. Forgetting Paste Special → Values. If you skip step 3, your helper column is still full of formulas pointing at column A. Delete column A and every result turns into an error. Always paste as values before deleting the original.

Frequently Asked Questions

How do I change text to uppercase in Excel?

Use the UPPER function: type =UPPER(A2) in a new cell, where A2 holds the text. Fill the formula down the column, then copy and Paste Special → Values to make the results permanent.

How do I change capital letters to lowercase in Excel?

Use the LOWER function: =LOWER(A2) turns every capital letter into a small letter.

How do I change text to title case in Excel?

Use the PROPER function: =PROPER(A2) capitalises the first letter of every word. Note that it capitalises every word, including small words like “and” and “the” — true title-case style guides leave those lowercase, so adjust them by hand if that matters.

Try It Yourself

Open a spreadsheet, type ali ahmed in cell A2, and try all three formulas in column B: =UPPER(A2), =LOWER(A2) and =PROPER(A2). You will see ALI AHMED, ali ahmed and Ali Ahmed side by side — and once you have seen it work, a whole column is just a double-click away. And if the text is not in a spreadsheet, our free Case Converter does the same job in one click.