Could somebody please tell me how to work the "proper" formula so that it
will change a column of names from all caps to just first letter cap?

I can get the formula to work for the first cell, but I can't get it to copy
or paste, or paste special to the column below it. (I don't use excel very
often and therefore have limited knowledge of these functions.)

Thank you!

jim_in_mich