Kat Morgan
New Member
- Joined
- Jul 15, 2015
- Messages
- 5
Hi all,
I am looking for vba code or a macro the will capitalize the first letter of each word, and does not make any changes to acronyms.
I am aware of the proper function, however it changes the letters in an acronym to lower case, except for the first. Is there a way to do this, either by maybe having the code exclude words in the cell that are 3 characters or less, or by excluding words that already start with a capital? I would love any help or suggestions!
Here are examples of what I am looking for:
From: hi my name is kat
To: Hi My Name Is Kat
From: managers IMR Report june
To: Managers IMR Report June
Thanks!
Kat
I am looking for vba code or a macro the will capitalize the first letter of each word, and does not make any changes to acronyms.
I am aware of the proper function, however it changes the letters in an acronym to lower case, except for the first. Is there a way to do this, either by maybe having the code exclude words in the cell that are 3 characters or less, or by excluding words that already start with a capital? I would love any help or suggestions!
Here are examples of what I am looking for:
From: hi my name is kat
To: Hi My Name Is Kat
From: managers IMR Report june
To: Managers IMR Report June
Thanks!
Kat