Hi, Sebastien! :)
*******************
~Anne Troy

www.OfficeArticles.com


"sebastienm" wrote in message
...
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?