You can use =Proper(a1) to change cell A1 from upper case to "title" case.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Mamacsee" wrote in message
...