Making first letter of each word capital

I'm not sure if this is difficult, easy or impossible but I'm dealing with a worksheet that is in all caps and I need to make only the first letter of each word capitalized while the rest being lowercase. Please direct me to the right place if this question was already answered!

Thanks.

If cell A1 =

THIS IS THE MAIDEN ALL FORLORN THAT MILKED THE COW WITH THE CRUMPLED HORN

In cell A2 enter = PROPER(A1)

Result:

This Is The Maiden All Forlorn That Milked The Cow With The Crumpled Horn

Quick thing, Now I understand how to make the first letter in each word capital, how do I repeat it many times, for instance I have A1-A170 that need to be formatted to the first letter capital situation mentioned above. How would I just replicated that result quickly?

Sorry, I'm new at this, I'm not sure I understand the vbProperCase command, where do I put that? Just really quick instruction on how to do this would be so helpful. thanks.