Help with Proper worksheet Function

I have 2 separate columns with approx. 5000 names in each. They are all in caps and I need to make them all Proper. Is there a formula that I can do for the whole column instead? I know how to do each cell separately but can't seem to drag it without the name following.

Please help.

Just thought I would let you know I figured a way to do it so thank you all for taking the time to read and possibly help.

Thanks again.