Capitalize the First Word in Excel

How-to basics · Updated November 20, 2026

To capitalize the first letter in a text cell while leaving the rest of the text unchanged, enter =UPPER(LEFT(A2,1))&MID(A2,2,LEN(A2)) in a neighboring cell, replacing A2 with the cell you want to fix. For example, it changes “hello there” to “Hello there.” This guide is for Excel for Microsoft 365 on Windows; the same formula works in Excel for Mac and Excel for the web.

What You’ll Need

  • An Excel workbook with the text you want to change. Keep a copy of the original data until you have checked the results.
  • An empty column beside the source data for the formula results. For example, if the text is in column A, use column B.
  • A basic understanding of what you mean by “capitalize the first word.” The main formula capitalizes only the first character of the cell. It does not convert every letter in that first word to uppercase.

Step-by-Step

  1. Identify the text column. Find the first cell containing a value you want to change. In this example, the original text is in A2, and the next rows contain more text in A3, A4, and so on. Using a separate output column keeps the original data available for comparison and recovery.
  2. Select the matching cell in an empty column. Click B2 if the source text is in A2. The result formula should refer to the source cell on the same row. If your source is in C5 instead, put the formula in another cell on row 5 and change its reference to C5.
  3. Enter the formula. With the source text in A2 and the result going in B2, enter =UPPER(LEFT(A2,1))&MID(A2,2,LEN(A2)) in B2, then press Enter. LEFT takes the first character, UPPER converts it to uppercase, and MID adds the remaining characters back without changing their case. The ampersand joins the two pieces.
  4. Check the result before filling further. If A2 contains “hello there,” B2 should show “Hello there.” If A2 contains “hELLO there,” the result is “HELLO there,” because this formula changes only the first character; it deliberately preserves the original case of everything after it. Confirm that this matches what you intend.
  5. Apply the formula to the other rows. Select B2 and point to the small square at the bottom-right corner of the selection, called the fill handle. Drag it down alongside the source data. Alternatively, double-click the fill handle to fill down alongside a continuous block of data in column A. Check the final rows, especially if there are blank cells in the source column.
  6. Review the filled results. Compare several outputs with their originals, including a short entry, a longer entry, and any unusual text. Each result should capitalize the first character of the corresponding source cell. If your list includes leading spaces, punctuation, or values that are not plain text, consult Troubleshooting before replacing the originals.
  7. Keep formulas or replace them with values. Leave the formulas in column B if you want results to update when the text in column A changes. If you need fixed text instead, select and copy the completed results, then use Home > Paste > Paste Values. This puts the displayed text in the selected cells without formulas.
  8. Replace the original column only if necessary. Once you have checked the results, you can copy the values in B and paste them over column A using Home > Paste > Paste Values. Do this only if you no longer need the original wording or have saved a backup. If you paste the formulas themselves over column A, the references can change and produce incorrect results.

In Excel for Mac, enter the same formula and use the fill handle to copy it down. Excel for the web also supports this formula and fill-handle method. Ribbon labels can vary slightly by platform or update, but you can use the formula wherever Excel is available.

Common Mistakes

  • Using PROPER when only the first letter should change. PROPER capitalizes the first letter of every word and generally makes the remaining letters lowercase. For example, it changes “the QUICK guide” to “The Quick Guide,” not “The QUICK guide.” The formula above changes only the cell’s first character.
  • Expecting the whole first word to become uppercase. “Capitalize” can mean uppercase the initial letter or convert every letter in a word to uppercase. The main formula does the first. If you need “HELLO there” from “hello there,” use the alternate formula in Tips.
  • Typing the formula into the source cell. A formula that refers to the same cell it occupies creates a circular reference. Put the formula in a different column, then copy and paste values over the source only after checking the results.
  • Including the wrong reference. If you copy a formula based on A2 into a row where the text is in C, Excel will still be looking at the wrong column. Make sure the reference points to the cell containing the text for that row.
  • Overwriting the formula with its own result too soon. When you paste, choose Paste Values, not a regular paste of the formulas. Keep an untouched copy until you know the text is correct.

Tips

  • Use PROPER only when every word should be title-cased. With text in A2, =PROPER(A2) changes “a quick guide to excel” to “A Quick Guide To Excel.” This may not suit names, acronyms, or sentence-style text because it changes the case throughout the entry.
  • Uppercase the entire first word when that is the intended result. With the text in A2 and the output in B2, enter =UPPER(LEFT(A2,FIND(" ",A2&" ")-1))&MID(A2,FIND(" ",A2&" "),LEN(A2)). For “hello there,” the result is “HELLO there.” Adding a space to the text searched by FIND lets the formula handle an entry with no spaces, such as “hello,” as well. It preserves the space after the first word. It treats the first run of text before a space as the word, so check how it behaves with punctuation or leading spaces.
  • Preserve the formula when the source may change. A formula result updates when its referenced cell changes. Use Paste Values only when you need a static result, such as preparing a final export or replacing a column of source text.
  • Consider spaces before the first character. The simple formula changes the first character, even if that character is a space. If your data has unwanted spaces at the beginning, clean the text first or use a separate cleaned column. TRIM can remove leading and trailing spaces and reduce repeated spaces between words, but that also changes spacing in the rest of the entry.
  • Try the method on a few rows first. Names, abbreviations, product codes, and mixed-case terms may have intentional capitalization. Check those examples before applying a change to a long list.

Troubleshooting

  • The result is unchanged. Check whether the first character in the source is already uppercase or is a space, digit, or punctuation mark. UPPER changes lowercase letters; it cannot turn a number or punctuation mark into a letter. If there is a leading space, the first character being changed is that space, not the first visible letter.
  • You see #VALUE! or an unexpected result. Confirm that the formula refers to the intended source cell and that the cell contains ordinary text. If the entry begins with a number, Excel may still return a text result, but the formula only changes letters. Check for unusual imported characters or errors in the source cell.
  • Excel displays the formula instead of the answer. The cell may be formatted as Text, or Show Formulas may be on. Change the output cell format to General, then edit the formula by pressing F2 and Enter. In Windows Excel, Ctrl+` toggles Show Formulas; the backtick key is usually above Tab. On a Mac, use the Formulas tab and check Show Formulas if the shortcut differs in your setup.
  • The output does not update after editing the source. If you pasted values, the output is fixed and will not update. If you kept formulas, check that calculation is set to Automatic under Formulas > Calculation Options > Automatic. You can also select the formula cell and press F2, then Enter to recalculate it.
  • Some rows are missing results. Check whether the fill handle stopped early or the source column has gaps. Select the formula cell and drag the handle across the full range, or select the output range and use Home > Fill > Down. Verify that the top cell in the range contains the correct formula before filling.

Frequently Asked Questions

Can Excel capitalize only the first letter of a cell?
Yes. Use the main formula in a neighboring cell. It uppercases the first character and keeps the rest of the text’s existing capitalization.

Does the formula capitalize the first letter after a period?
No. It changes only the first character in the cell, not the first character of every sentence. For multiple sentences, you would need a more involved solution or careful manual editing.

How do I capitalize the whole first word?
Use the alternate formula in Tips. It converts the text before the first space to uppercase and leaves the rest of the entry as it is. Check punctuation and leading spaces in your data.

Can I change the text without using a formula?
For a small number of cells, edit them manually. Excel’s Change Case commands do not provide a one-click option to capitalize only the first character of each selected cell. For a larger list, a formula is usually easier to review and fill down.

Will the formula work in Excel for Mac or the web?
Yes. UPPER, LEFT, MID, LEN, and the ampersand operator work in current Excel for Microsoft 365 on Windows, Mac, and the web. Use the fill handle if a keyboard shortcut differs on your device.

How do I remove the formula but keep the corrected text?
Copy the result cells, then choose Home > Paste > Paste Values. The cells keep the displayed text, and the formulas are removed. Keep a backup if you may need to restore the original entries.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.