Goto the following link and download ASAP Utilities, its free.
http://www.asaputilities.nl/

One of the options in 'Text' in this utility is to Change case.
It also has numerous other useful bits and pieces for Ecel.

Enjoy


--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=542509