How can I convert all Caps to first letter caps in Excel?

[Guest]

I have a large worksheet in a database I am building and am transporting some
files that are all caps. Is there any possible way that I can change it to
small font except for the first letter of the word? Eventually I am going to
be creating mailing lists and feel it would be more presentable in this type
of format.

 

[Guest]

Hi

Have a look at the PROPER function

 

[Anne Troy]

Try this:
http://www.officearticles.com/excel/change_the_case_of_text_in_cells_in_microsoft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Guest]

Thanks Andy, saves alot of time..

Hi

Have a look at the PROPER function

 

[Guest]

Anne-
Thanks, saved me alot of time
J

Try this:
http://www.officearticles.com/excel/change_the_case_of_text_in_cells_in_microsoft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Guest]

Thanks for the feedback!

--
Andy.

Thanks Andy, saves alot of time..