would the function be: =Proper(a2) - YES
would I enter this function in cell A2 - NO

You must enter the function in an empty cell


"Polly" wrote:

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?