View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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