Change JOHN HANDCOCK to John Handcock?

I've tried searching the forums for another post addressing this, but can't find any.
So if you know of one that's already "solved" - it's okay to redirect me to that...

Example Problem: I have a huge list of NAMES and ADDRESSES -- ALL IN CAP
Wanted Solution: I'd like to get all of the Names and Addresses to be in Lower Case, except for the 1st letter of each name/word.

I've already tried this formula, which returns "John handcock" (little "h"):
=LEFT(A1,1)&LOWER(RIGHT(A1,LEN(A1)-1))

I've even tried SUBSTITUTE, but it only adds the name again "John handcockJOHN HANDCOCK" (without recognizing the first part of the formula):
=LEFT(A1,1)&LOWER(RIGHT(A1,LEN(A1)-1))&SUBSTITUTE(A1," h"," H")

So the question... Is there an easy way to do this?
Or do I need to write a macro with the first formula, and then a separate Substitute formula for every letter of the alphabet?
I understand if that's the only way - but it seems like a lot of work for something so minor...

Any suggests, big or small, are most welcome!
Thanks so much!!
M

Try the PROPER() function

e.g..=PROPER(A1)

Have you tried the PROPER() function?

Example:
A1: ALPHA BRAVO CHARLIE

B1: =PROPER(A1)
That formula returns: Alpha Bravo Charlie

Does that help?

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save