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.

I'd cheat and use another column.

=proper(a1)

to get the first letter of each word uppercase.

Then use that field in the mailmerge.

rt wrote:

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.

--

Dave Peterson

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.