Make a helper column or a help spreadsheet and use LOWER() function.
Just copy and paste value after to replace original.


Teri Wrote:
I have a large spreadsheet which I am using as merge data for a letter.
Some
of the data is in all caps. How can I convert this to lower case?


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=388029