How do I convert a line of text to title case?

rcbjr2 · #14 09-16-2020, 07:18 AM

Quote:

Originally Posted by Charles Kenyon

My grammatical skills may be rusty, but for US use, I use the following exclusion list which does not include pronouns but does include conjunctions and prepositions:

Code:

    Let StrExcl = "(a),a,an,and,as,at,(b),be,but,by,(c),cm,(d),(e),eg,en,eq,etc,(f),for," & _
              "(g),(h),(i),ie,in,into,(j),(k),(l),(m)," & _
              "mm,(n),na,nb,(o),of,off,on,or,(p),(q),(r),re,(s),(t),the," & _
              "to,(u),(v),via,vs,(w),with,(x),(y),yd,(z)"

This is great. Thanks.

-Rich

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
creating a new TITLE property from text already within document	smndnm	Word VBA	6	07-04-2014 08:27 PM
Stop review query when small case at beginning of line	dsrose	Word	2	01-22-2014 12:19 AM
True Title Case for First Row of All Tables	Marrick13	Word VBA	14	12-11-2013 09:12 PM
Custom Text Filter for this particular case	tinfanide	Excel	2	09-13-2011 05:08 AM
From all UPPER CASE to Proper Case	davers	Word	1	04-30-2009 12:41 PM