How to Make First Letter Capital in Excel (PROPER Function)

This tutorial takes about 2 minutes to complete.

Before you start

Excel has a built-in function called PROPER that capitalizes the first letter of every word in a text string while leaving all other letters lowercase. This tutorial shows how to apply it to an entire column of names (or any other text), and then lock the results in place so they stop updating when the original data changes.

Step 1: Enter the PROPER formula

In your spreadsheet, you should have text in one column — for example, names in column A where only some first letters are capitalized. Click into a blank cell next to it (column B, row 1), type =, then the PROPER function with a reference to the first cell of your data:

=PROPER(A1)

Hit Enter. The content of cell A1 now appears in proper case — every word's first letter capitalized, all other letters lowercase — in this cell.

Step 2: Fill the formula down to all rows

To apply the same formula to every row below, click back on the cell with your formula (B1). Move your cursor to the bottom-right corner of that cell until it turns into a black plus sign (the fill handle), then double-click. Excel automatically fills the formula down through all adjacent rows that have data in column A.

One thing to remember: column B isn't a fixed copy of column A — it's a live formula. If you change or add text in column A, the matching cell in column B updates automatically with the new proper-cased version. This is convenient if your source data keeps changing, but if you want the properly cased text to stay fixed instead, see Step 3 below.

Step 3: Paste as values to make the text static

If you want the properly cased results to stop updating when column A changes, convert them from formulas to plain text:

1. Highlight all the cells in column B that contain your formula results.
2. Right-click and choose Copy.
3. Click on column A (the header or any cell in the column).
4. Right-click again and choose Paste Special → Values (the icon with "123" on it).

This replaces the formulas in column A with their current properly cased results as plain, unchanging text. Your data is now locked in proper case form. If you no longer need the formula column, you can delete column B afterward since it's now redundant.