How to Use the PROPER Function to Capitalize the First Letter of Each Word in Excel

When you inherit an Excel spreadsheet filled with customer names or product titles that were typed carelessly, you often face a formatting nightmare. You might have entries like “jOhn sMiTh” or “ALICE jones.” Manually retyping hundreds of names so that only the first letter of each word is capitalized is not an option. Instead, you can instantly fix the entire column using Microsoft Excel’s built-in PROPER() function.

How the PROPER Function Works

The PROPER() function takes a string of text and mathematically forces the very first letter of every distinct word to be uppercase, while forcing every subsequent letter in that word to be lowercase. Because it is a function, it generates this new, corrected text in a separate column.

Step-by-Step Guide

1. Open your Excel spreadsheet and locate the column with the poorly formatted text (e.g., Column A).
2. Click into an empty cell in a new, adjacent column (e.g., Cell B1).
3. Type the following formula: =PROPER(A1)
4. Press Enter. The text from A1 will appear in B1, perfectly formatted (e.g., “jOhn sMiTh” instantly becomes “John Smith”).

Applying the Fix to the Entire Dataset

To apply this correction to every single row in your spreadsheet simultaneously:

1. Click once on cell B1 (the cell with the formula).
2. Look for the tiny dark green square in the bottom-right corner of the cell (the Fill Handle).
3. Double-click the tiny green square.

Excel will instantly copy the formula down the entire column, automatically converting every single messy entry into proper title casing.

Finalizing the Data

Because the clean text in Column B relies on the messy text in Column A via a formula, you cannot simply delete Column A yet. If you do, Column B will break. You must convert the formulas into permanent text.

1. Highlight all the clean text in Column B.
2. Press Ctrl + C to copy it.
3. Right-click on the highlighted text, look under “Paste Options,” and click the 123 icon (Paste as Values).

The formulas are now gone, replaced by static text. You can safely delete the original messy Column A.