Hi,

Say data is in A1.
In B1, use the LOWER( ) function: =LOWER(A1)

To convert to uppercase, use the UPPER function and to convert to Propercase
(1st letter of each word uppercase and the rest lowercase) use the PROPER()
function
--
Regards,
Sébastien


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