How to change character to lower case except the first letter?
 

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.

How to change character to lower case except the first letter?
 

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

How to change character to lower case except the first letter?
 

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.