This is easier then it looks.

Let's say all you names are in the column A and B. And you have written the formula =PROPER(A1) in cell C1.

If you put the cursor in C1 you will see that C1 is marked as a bold rectangel. However in the right bottom corner of that rectangle is a tiny small square.

If you double click on that tiny square, your formula will be copied down - as far as Excel can find names in column B.

You can also grab hold of the tiny square and drag-copy down your formula.

If anything goes wrong. Just use the undo button.

Ola