I dump the data into Word. Then select all text and click on Format - Change
Case. Then I dump it back to excel.

"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?