I know that a formula would work, but I don't know what it is
and more importantly, where to put it.
In other words, if the "all caps name" is in E3 to E120
and I want to change these cells to "proper case"
Note that I already tried putting this formula in A1
=PROPER(A2)
to change an "all caps" name in A2, but it didn't change it.
What exactly do I do for this?
If you will be providing me with a formula, then please tell me exactly
where to put it and how to put it there.
Thanks so much
--
duugg
------------------------------------------------------------------------
duugg's Profile:
http://www.excelforum.com/member.php...o&userid=33372
View this thread:
http://www.excelforum.com/showthread...hreadid=535552