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

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?

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?
--
Regards,

DaveB


"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?

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?

Yes, thank you.
Polly

"DaveB" wrote:

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?
--
Regards,

DaveB


"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?

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.

lol