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