![]() |
#1
|
|||
|
|||
![]() Greetings to all, I am working on a document where I have to change the heading to uppercase and while doing so, I have to be careful because I cannot change any preposition like the, on, in, with, a, and, etc. So, what I am really trying to do is 'Change all the first letters of the word to uppercase excluding some words listed above. I have attached a sample file, plz have a look and suggest a solution. Thanks in advance. |
#2
|
||||
|
||||
![]()
See the True Title Case example code on my web site at VBA Code Examples (2)
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
|||
|
|||
![]()
Thanks, sir for the reply. The code that you have provided exactly met my needs.
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to apply sentence case but maintain upper case for things like UK, USA, etc | drrr | Word VBA | 0 | 09-20-2021 12:19 PM |
![]() |
gloub | Word VBA | 2 | 01-30-2019 12:40 PM |
Hard return renders upper case | clafond | Word | 2 | 01-07-2013 12:26 PM |
![]() |
davers | Word | 1 | 04-30-2009 12:41 PM |
Upper to lower case | jd | Excel | 1 | 04-28-2006 07:40 AM |