There is an UPPER and LOWER function (=LOWER(A2))

If you use this and copy/paste special (values) I'm sure you could
resolve.


--
SAP PoD
------------------------------------------------------------------------
SAP PoD's Profile: http://www.excelforum.com/member.php...o&userid=37641
View this thread: http://www.excelforum.com/showthread...hreadid=573001