Proper Case in Excel: UPPER, LOWER, and PROPER

Proper case in Excel means capitalizing the first letter of each word in a text value, and it is one of three case functions — UPPER, LOWER, and PROPER — that Excel offers instead of a Change Case button. Unlike Word, Excel makes you write a formula in a helper column and paste the result back.

Why casing matters in a data column

Inconsistent casing looks cosmetic and behaves like a data error. A column that holds ACME LTD, Acme Ltd, and acme ltd reads as one company to a person and three companies to most software. Pivot tables produce three rows. COUNTIF splits the total three ways. A CRM importer matching on an exact string creates three records where you meant one.

The same trap catches contact data. Email addresses are the common case: a de-dupe pass that compares raw text treats [email protected] and [email protected] as different people, so both rows survive and both land in your CRM. Normalizing case is what makes the duplicate remover actually collapse those pairs, which is why casing belongs near the start of a cleanup rather than the end. The same logic applies to stray whitespace, covered in removing spaces in Excel — trim first, fix case, then deduplicate.

Casing also matters for anything a human will read. A list exported from a web form arrives in whatever people typed: all caps from someone with caps lock on, all lowercase from a phone keyboard. Sending a mail merge that opens with "Dear JOHN" is the kind of error that gets noticed.

The three case functions: UPPER, LOWER, and PROPER

Excel has no Change Case command on the ribbon. Microsoft's guidance is to use a formula in a temporary column, then paste the values back over the original [1]. The three functions each take one argument, the text you want to convert:

• =UPPER(A2) returns ACME LTD — every letter uppercase.
• =LOWER(A2) returns acme ltd — every letter lowercase.
• =PROPER(A2) returns Acme Ltd — the first letter of each word uppercase, everything else lowercase.

Numbers, punctuation, and spaces pass through all three untouched, so a value like Suite 4B, 12 High St keeps its digits and commas whichever function you use.

The full pass looks like this:

1. Insert a blank column to the right of the column you want to change.
2. In the first cell of the new column, type =PROPER(A2), replacing A2 with the first cell of your data.
3. Press Enter, then double-click the fill handle in the bottom-right corner of the cell to copy the formula down the whole column.
4. Select the new column, copy it, then right-click the original column and choose Paste Special > Values.
5. Delete the helper column.

Step 4 is the one people skip. If you leave the formula in place and delete the source column, every result turns into a reference error, because the formula no longer has anything to read.

For a LOWER pass on emails, that whole sequence is worth avoiding entirely — the email column cleaner lowercases and trims an address column in one step, without a helper column or a Paste Special.

Where PROPER gets names wrong

PROPER is the function people reach for on a name column, and it is the one most likely to produce output you have to correct by hand. Microsoft's own documentation defines the behavior precisely: it capitalizes the first letter in a text string and any other letter that follows a character other than a letter, and converts everything else to lowercase [2].

Read that rule again, because it explains every strange result:

Google Sheets behaves the same way and its help page uses the same class of example, noting that mcLeod comes back as Mcleod rather than McLeod [4]. This is not a bug in either product; capitalization rules for human names are genuinely inconsistent, and no single function encodes them.

The practical consequence: never run PROPER across a name column and ship the result unchecked. Sort the output alphabetically and scan for the patterns that break — Mc, Mac, O', van, de, von, and any all-caps company initialism — then fix those rows manually. If your name column also needs splitting into first and last, do the split first with the name splitter so you are checking two short columns rather than one long one.

Change case without a formula using Flash Fill

Flash Fill is the closest Excel gets to a Change Case button. Type the corrected version of the first value into the column beside your data, start typing the second, and Excel offers to fill the rest from the pattern it detected. If it does not offer, run it manually from Data > Flash Fill or Home > Flash Fill, or press Ctrl+E [3]. If the automatic preview never appears, the feature can be switched on under File > Options > Advanced with the "Automatically Flash Fill" box [3].

Flash Fill has a real advantage over PROPER on messy name data: it learns from the examples you give it, so if you type McLeod yourself, it is more likely to keep that shape in similar rows than a function following a fixed rule. It also writes plain text, not formulas, so there is no Paste Special step.

The trade-off is that it is a guess. Flash Fill infers a pattern from one or two examples and applies it silently to hundreds of rows, and it does not tell you which rows it was unsure about. Give it two or three examples rather than one, and check the bottom of the column as well as the top. The broader mechanics are covered in the guide to Flash Fill in Excel.

Fix casing in a CSV without uploading it

If the file you are fixing is a CSV headed into another system, opening it in Excel to change case can cost you more than it fixes. Excel drops leading zeros from postal codes on open, reformats anything that looks like a date, and pushes long IDs into scientific notation — problems that did not exist in the source text, as opening a CSV in Excel sets out.

A CSV is plain text, so casing can be normalized without a spreadsheet grid at all. Sigmera's browser-based cleaning tools run entirely on your own device: the file is read inside the tab, processed by client-side code, and never sent to a server. For a contact list holding names, emails, and phone numbers, that difference matters more than the convenience — nothing personal crosses the wire, which keeps the pass GDPR-safe by default. Lowercasing an email column, standardizing values with find and replace, then removing the duplicates that the casing fix exposed all happen in the same tab, and previewing every step is free — only exporting the finished file counts against a plan, as the pricing page explains.

Use Excel when the data lives in a workbook and stays there. Use the browser route when the file is a CSV in transit, and reach for PROPER knowing exactly which names it will get wrong.