Hi "rt",
I'd use a macro and do it in place, even if you needed the old data
in upper case, in which case you could work from a copy of the page.
See
http://www.mvps.org/dmcritchie/excel/proper.htm
Assume you mean propercase, You could mean sentences,
either way you will find information on the above page.
FWIW, I also have a page on Mail Merge that certainly points to the above
so I know you've not seen this particular page. It is oriented to printing labels.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
I'm creating a mail merge, all my contents are in upper case and i would like
to change the character to lower case except for the first letter of each
word.