Is there any way using VBA to capitalize every proper word in a sentence?
For example for the sentence:
Beginning in 1910, the automobile industry sprang up in Detroit with 125 different auto companies. The rise of the city’s automobile industry spawned an upward movement of population and...