Capitalize First Letter in Excel: Step-by-Step

This guide shows you how to capitalize the first letter of a text string in Microsoft Excel, turning entries like “john smith” into “John smith” without retyping. You’ll learn the core formulas (PROPER, UPPER, and a combination of LEFT, MID, and UPPER) and how to apply them to your data. No prior Excel formula experience is needed, just a spreadsheet with your text.

What You’ll Need

Microsoft Excel (2010 or later, including Microsoft 365) on Windows or Mac.
A worksheet containing the text strings you want to modify.
A blank column next to your data where the formula results will appear.

Step-by-Step

Method 1: Using the PROPER Function (Capitalizes the First Letter of Every Word)

Identify your data range. For example, your text is in column A, starting at A2 (assuming A1 is a header).
Select the first cell in a blank column next to your data, such as B2.
Type the formula: =PROPER(A2) and press Enter. This converts “john smith” to “John Smith” and “JOHN SMITH” to “John Smith”.
Copy the formula down. Click on the fill handle (the small square at the bottom-right corner of the cell) and drag it down to cover all rows that have data in column A.
Replace the original data (optional). Select the formula cells, press Ctrl+C (or Command+C on Mac), then right-click and choose “Paste Values” under Paste Options. This replaces formulas with static text. You can then delete the original column if desired.

Method 2: Capitalize Only the First Letter of the String (Not Every Word)

If you want “john smith” to become “John smith” (only the first letter capitalized), use this formula:

In a blank cell (e.g., B2), type: =UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2)-1)) and press Enter.
How it works: LEFT(A2,1) grabs the first character, UPPER() makes it uppercase, MID(A2,2,...) extracts the rest starting from the second character, and LOWER() makes the rest lowercase (so “JOHN” becomes “John”). The ampersand (&) joins them.
Copy down using the fill handle as in Method 1.

Method 3: Capitalize the First Letter After a Specific Character (e.g., After a Period or Hyphen)

For strings like “hello.world”, you might want “Hello.World”. Use this more advanced formula:

In a blank cell, type: =UPPER(LEFT(A2,1))&SUBSTITUTE(LOWER(MID(A2,2,LEN(A2)-1)),". "&" ",". "&" ") – this is not quite right. Instead, use the following array formula (enter with Ctrl+Shift+Enter in older Excel, or just Enter in Excel 365):
Simpler approach: Use a helper column. First, use =LOWER(A2) to make all text lowercase. Then, use a formula to capitalize letters that follow a period. For example, if your text is in C2 (lowercased), use: =UPPER(LEFT(C2,1))&SUBSTITUTE(C2,". "&MID(C2,2,1),". "&UPPER(MID(C2,2,1))) – this gets messy. The cleanest way is to use a VBA macro or Power Query, but for most users, the PROPER function is sufficient.
For a single delimiter like a period, use this formula: =UPPER(LEFT(A2,1))&SUBSTITUTE(LOWER(MID(A2,2,LEN(A2)-1)),". ",". ") will not work. Instead, use the following which capitalizes the letter after a period and a space: =UPPER(LEFT(A2,1))&SUBSTITUTE(LOWER(MID(A2,2,LEN(A2)-1)),". "&MID(LOWER(A2),FIND(". ",LOWER(A2))+2,1),". "&UPPER(MID(LOWER(A2),FIND(". ",LOWER(A2))+2,1))) – this is overly complex for a general guide. The practical solution is to use the PROPER function, which handles most cases, or use Flash Fill (see Tips).

Common Mistakes

Using PROPER when you only want the first letter. PROPER capitalizes every word, which is not always what you want (e.g., “john smith” becomes “John Smith”, not “John smith”).
Forgetting to convert formulas to values. If you delete the original column without pasting values, your formulas will return #REF! errors.
Assuming PROPER handles all punctuation. PROPER capitalizes letters after any non-letter character, so “o’clock” becomes “O’Clock”. That may be incorrect.
Not accounting for leading spaces. If your text has a leading space, LEFT(A2,1) returns a space, not the first letter. Use TRIM(A2) first.

Tips

Use Flash Fill for quick, one-off conversions. In a new column, type the first few examples manually (e.g., “John smith”), then press Ctrl+E (Flash Fill). Excel will detect the pattern and fill the rest.
Combine with TRIM. Use =PROPER(TRIM(A2)) to remove extra spaces before capitalizing.
Handle empty cells. If a cell is blank, the formula returns an empty string, which is fine. If it returns 0, wrap with IF(A2=””,””,…).
For a true “first letter only” capitalization that doesn’t lower the rest, use: =REPLACE(A2,1,1,UPPER(LEFT(A2,1))) – this keeps the rest of the string exactly as is, just capitalizing the first character.

Troubleshooting

Formula returns #NAME? This usually means you misspelled the function name (e.g., PROPER vs PROPRE). Check for typos.
Formula returns #VALUE! This can happen if the cell contains a number, not text. Ensure your data is stored as text. Convert numbers to text using TEXT(A2,”0″) if needed.
Results don’t update when I change the source. If you used Paste Values, the results are static. Re-enter the formula or use Flash Fill again.
PROPER doesn’t capitalize the letter after a hyphen correctly. For example, “mary-jane” becomes “Mary-Jane” which is often desired, but if not, use the REPLACE method above.
The fill handle doesn’t work. Make sure your Excel has fill handle enabled. Go to File > Options > Advanced, and under Editing Options, ensure “Enable fill handle and cell drag-and-drop” is checked.

Frequently Asked Questions

Can I capitalize the first letter of each word in a sentence?

Yes, use the PROPER function. It capitalizes the first letter of every word, which is ideal for names, titles, or addresses.

How do I capitalize only the first letter and leave the rest as is?

Use the formula =REPLACE(A2,1,1,UPPER(LEFT(A2,1))). This only changes the first character to uppercase and leaves everything else untouched.

What if my text has leading spaces?

Wrap your text with TRIM first: =PROPER(TRIM(A2)) or =REPLACE(TRIM(A2),1,1,UPPER(LEFT(TRIM(A2),1))).

Does this work in Google Sheets?

Yes, the same formulas (PROPER, UPPER, LEFT, etc.) work identically in Google Sheets.

Why does PROPER capitalize the letter after a number or symbol?

PROPER treats any non-letter character as a word delimiter. So “123abc” becomes “123Abc”. If you want to avoid that, use the REPLACE method.

Can I do this without formulas using a menu option?

Yes, use Flash Fill. Type the desired result in the first cell, then press Ctrl+E. Excel will fill the rest based on the pattern.

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →