Select the range of cells that you want to change cases on.
Select "OK"
A box will appear with the options...Upper Case / Lower Case / Proper Case /
Cancel.
Cancel will be the default.
Select the 'Proper Case' button
Select "OK"

Your selected text should now be Proper Case.
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"JPriest" wrote:


Hi Gary,
What a code!
However, when i run it, it only provides me with a box which contains
the cell with the text in it, it doesn't change to the proper case. I
would like the text to read Mr. Joe Smith instead of Mr. JOE SMITH.

Thanks again,
Jeff


--
JPriest
------------------------------------------------------------------------
JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
View this thread: http://www.excelforum.com/showthread...hreadid=393931