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

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




duugg Wrote:
Ugh! This is driving me crazy! Why is it not changing the names to
proper??

Sorry everyone, I feel oblivious to this. I've attached a pic of the
spreadsheet to show everyone that it's not changing the text to
proper.

I do have it set to automatic as well.

Again, thanks for everyone's help on this.


--
FireWater
------------------------------------------------------------------------
FireWater's Profile: http://www.excelforum.com/member.php...o&userid=33846
View this thread: http://www.excelforum.com/showthread...hreadid=535552

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*.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=535552

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?


--
duugg
------------------------------------------------------------------------
duugg's Profile: http://www.excelforum.com/member.php...o&userid=33372
View this thread: http://www.excelforum.com/showthread...hreadid=535552