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