I am trying to use the proper function in a large list. When I try to use the
proper function, the returned result is "0".

If cell A2 contains billy BoB thoRton, would the function be:
=Proper(a2) and would I enter this function in cell A2?