How do I use the "Proper" function? The instructions are vague.

[Guest]

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?

 

[Guest]

No you would enter this function in any cell BUT A2. For example, if A2
contains the value "billy BoB thoRton" as you said, then placing the function
=PROPER(A2) into cell A3 would output "Billy Bob Thorton"

Does that help?

 

[Guest]

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

 

[Guest]

Yes, thank you.
Polly

No you would enter this function in any cell BUT A2. For example, if A2
contains the value "billy BoB thoRton" as you said, then placing the function
=PROPER(A2) into cell A3 would output "Billy Bob Thorton"

Does that help?

 

[Blue Hornet]

As the earlier posters have demonstrated, you have to use it (please
excuse me, and I'll never do this again until the next time) proper-ly.

 

[Guest]

lol