Text in Upper case: C:\MY DOCUMENTS\EXCELTIP.XLS The Function: =LOWER(A1) Result - Text in Lower case : c:\my documents\exceltip.xls