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?