WOW! thanks! i never knew you could change the text from lower to upper
with just a code. I have to move data that is sent to me onto another
database and most of the time it is sent to me with lower case (when it
should be upper) and vice versa.
now i dont have to keep pestering them! Thanks!


--
SarahKay
------------------------------------------------------------------------
SarahKay's Profile: http://www.excelforum.com/member.php...o&userid=24330
View this thread: http://www.excelforum.com/showthread...hreadid=379146