dlw

If I put the formula into cell , I get the following error message
=PROPER(#REF!). Then I put the name, let's say, John Smith in the same
cell, but it types over the formula, resulting in erasing it.

I also tried putting "=Proper (A2)" into cell A1 and then typing john
smith (just like that, all lowercase) in cell A2, but it does not
change the case to proper after pressing enter, it just stays like it
was.


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