How do I change the case from all caps to proper for names I have in columns E, F, G?

[FireWater]

There is something wrong with the picture you posted.
F1 should not be displaying "=PROPER(E1)"

try using another column eg column G and try typing =proper(e1) note in
lowercase. Excel should automatically convert it to uppercase if it
recognized it as a valid excel function, otherwise set it General and
then try retyping the formula

 

[starguy]

if you enter the formula =PROPER(E1) in F1 this have no impact on the
contents of E1. E1 will remain the same as *john smith*. But after you
enter the formula =PROPER(E1) in F1 and press enter, F1 then will show
you the contents of E1 in PROPER CASE like this *John Smith*.

 

[duugg]

No, text format is set to black as I see the name there in all small
fonts (no proper case).

Other than tools, options, calculation, automatic setting checked, is
there something else that should be checked to make this work?