Capitalize Names in Excel: Formulas and Methods

Formulas & functions · Updated November 19, 2026

To capitalize names in an Excel column, enter =PROPER(A2) in the next column, replacing A2 with the first name cell, then fill the formula down. PROPER changes text to title case, so jane smith becomes Jane Smith; if you mean all capital letters instead, use UPPER.

What Excel means by capitalizing names

People use capitalize to mean two different things: make the first letter of each name uppercase, or convert every letter to uppercase. For a list of people, the first meaning is usually wanted. Excel’s PROPER function applies that pattern to each word in a text string: it makes the first letter uppercase and the remaining letters lowercase. For example, jane smith becomes Jane Smith and MARIA GARCIA becomes Maria Garcia.

PROPER is a text-cleanup function, not a name-aware spellchecker. It does not know which letter patterns are correct for a particular person, language, or family name. That distinction matters when a list contains initials, acronyms, particles, or deliberately unusual spelling. The function can provide a quick, consistent starting point, but important records should be reviewed after conversion.

Use PROPER to capitalize a column

In Excel for Microsoft 365 on Windows, keep the original names and put the results in a new column. If the names are in A2:A100, for example, use B as the output column. With the first name in A2, enter =PROPER(A2) in B2. The result for a cell containing jane smith is Jane Smith.

  1. Select the first output cell beside the first name, such as B2.
  2. Type the PROPER formula and press Enter.
  3. Select B2 again and use the fill handle, the small square at the lower-right corner of the selection, to copy the formula down the list. You can drag it, or double-click it when the neighboring name column has continuous data.
  4. Check several results, especially names with punctuation or nonstandard spelling, before replacing any original data.

Excel adjusts the reference as it fills: the formula copied into B3 refers to A3, and the one in B4 refers to A4. If the source is an Excel table, adding the formula in the adjacent table column generally makes Excel fill the calculated column automatically. In Excel for Mac and Excel for the web, the formula syntax is the same; the fill handle is also available, though ribbon and menu layouts can differ slightly.

Choose the right capitalization formula

PROPER is appropriate when each word should begin with a capital letter. If the task instead calls for a different case, use the corresponding function. With source text in A2, =UPPER(A2) converts every letter to uppercase, while =LOWER(A2) converts every letter to lowercase. For example, UPPER changes jane smith to JANE SMITH, and LOWER changes JANE SMITH to jane smith. These functions also return results in another cell, so the source remains unchanged.

Use case consistently with the purpose of the data. A mailing list may call for title case, while a system code or an organization’s official abbreviation may need to remain uppercase. If you only want to capitalize a person’s first and last name, PROPER will also capitalize other words in the cell, such as a middle name or a title. Review the output rather than assuming that every word should always be treated alike.

Where PROPER can produce the wrong name

The most common limitation is that proper case is not the same as correct name styling. For instance, PROPER changes MCDONALD to Mcdonald, not necessarily the person’s preferred McDonald. It can also turn a short initial sequence such as USA into Usa. Names containing apostrophes or hyphens may be capitalized after punctuation, which can be useful in some cases but still may not match a person’s chosen form. Treat the result as a mechanical conversion, not a guarantee of correct spelling or identity.

Other examples worth checking include:

  • Prefixes and particles such as van, de, or von, whose capitalization depends on the person and context.
  • Names with internal capitals, such as McLeod or O’Neil, where an automatic function may not preserve the intended pattern.
  • Initials and credentials, such as J. R. or PhD, which may need selective capitalization.
  • Company names and product names, which can have brand-specific casing rather than ordinary title case.

For a small list, the practical approach is to apply PROPER, then correct exceptions manually in the output column. For a large or frequently refreshed list, keep a separate approved-name or exception list and use a controlled cleanup process. Do not overwrite the only copy of an important source column until the results have been checked.

Capitalize without a formula using Flash Fill

Flash Fill can infer a pattern from examples when you want the results as ordinary text rather than formulas. Suppose A2 contains jane smith. In B2, type Jane Smith. Start typing the next corrected name in B3; if Excel recognizes the pattern, it previews proposed entries for the rest of the list. Accept the preview, or choose Data > Flash Fill. On Windows, Ctrl+E is the Flash Fill shortcut. On Mac, use the Data tab command if the shortcut differs in your Excel setup.

Flash Fill is useful for one-time changes and for patterns more specific than title case, such as rearranging first and last names. It relies on the examples and the visible data, however, so inspect the entire result for inconsistent patterns or ambiguous entries. Unlike a formula, a Flash Fill result does not recalculate when the original name changes. It may also fail to offer a pattern if the examples are unclear.

Use Power Query for repeatable imports

If names arrive regularly from a file or a database, Power Query can apply a repeatable text transformation during import. In Excel for Microsoft 365 on Windows, select the source data and choose Data > From Table/Range to open the Power Query Editor. Select the name column, then choose Transform > Format > Capitalize Each Word. Review the preview and use Home > Close & Load to return the transformed data to Excel.

This method is useful when you refresh the same kind of source repeatedly: the transformation is part of the query and can run again when the source is refreshed. It still applies a general capitalization rule, so it does not solve the name exceptions described above. Power Query availability and authoring options vary by Excel platform; on Mac or in the web app, if the commands are unavailable or differ, use the formula method or perform the transformation in a supported desktop version.

Keep the results as values

A formula result depends on its source cell. That is useful while the list is being checked, but some workflows require fixed text. After confirming the converted names, select the output cells and copy them. Then choose Home > Paste > Values to paste the displayed text over the formulas or into another location. The original column can be retained as a backup or removed only after you have verified the values.

There is no need to convert formulas to values if you want the output to update when source names change. If you do replace the source column, copy the formula results first and paste values into the intended destination; otherwise, deleting the source cells can leave formulas referring to empty cells. Keeping the source and cleaned columns side by side also makes review and correction easier.

Common problems and checks

  • The formula displays as text: The cell may have been formatted as Text before the formula was entered. Change its format to General, then re-enter the formula.
  • The formula is not filling down: Drag the fill handle, double-click it beside a continuous data range, or copy the formula and paste it into the remaining output cells.
  • Blank rows create unexpected results: PROPER applied to an empty source cell returns an empty result. Check whether blanks in the source are intentional before sorting or exporting.
  • Only some names are wrong: This is usually a limitation of automatic capitalization, not a calculation error. Correct the exceptions in the output or use a more specific cleanup process.
  • The source data has extra spaces: Spaces at the beginning, end, or between words can affect presentation. Check and clean the source separately if those spaces appear in the output.

Before sharing or importing a cleaned list, scan for duplicate names, lost initials, and changed organization names. Capitalization does not make two different people distinguishable, and it does not correct misspellings. If the data is sensitive or used for official records, preserve the original and follow the relevant data-handling rules for that workbook.

Frequently Asked Questions

How do I capitalize the first letter of every word in Excel?
Use PROPER in a neighboring cell, such as =PROPER(A2) when the text is in A2, then fill the formula down. Review names whose official spelling uses unusual capitalization.

How do I make an entire names column uppercase?
Use UPPER in a separate column, for example =UPPER(A2) for a name in A2, and fill down. This converts every letter to uppercase rather than capitalizing only the start of each word.

Can I capitalize names in place without keeping a formula?
Use Flash Fill to create text in a neighboring column, or copy formula results and paste them as values. Excel formulas do not directly change the contents of the cells they reference.

Will PROPER correctly capitalize names like McDonald?
Not reliably. It applies a general word-capitalization rule and may return Mcdonald. Check special spellings manually or use a maintained exception list when accuracy matters.

Does PROPER work in Excel for Mac and Excel for the web?
Yes. PROPER is an Excel worksheet function and its syntax is the same across these versions. The ribbon locations for tools such as Flash Fill or Power Query can vary by platform.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.