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
gary_brown@ge_NOSPAM.com
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
>
>