Changing the 1st letter of each word in a field to Capital only

J

jp

We have a field ccalled PATSTR we pull it with mail merge. It pulls fine..
It is all caps so it comes over as '123 WASHINGTON ST' We use the *\Lower
*Firstcap field code to get the 1st letter to be cap so it comes out as
'123 washington st' becuase the 1st values is 1 not W. Is there a code
that changes the 1st letter of each word within a value to be capitalized?
so 123 WASHINGTON ST would be 123 Washington St


Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA word change keys 0
Changing name/address in Excel row to Word address block format 4
Matching literal text "???" in Word 2010 field code IF statement 2
How do I globally change all caps to lower case w/lst letter cap? 2
Capitalize first letter of each word 3
How can I convert labels to merge fields? 2
Mail merge hyperlink wrong results 0
Default Capital letter for 1st letter of a word 6

Top