Thread
:
Macro for changing text to Proper Case
View Single Post
#
4
Gary L Brown
Posts: n/a
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
Reply With Quote