Changing letter case on mass

Okay this may not be the normal excel type of question, but hopefully someone may be able to help?

I have an Excel sheet where everything is TYPED IN CAPITALS.

I could work through the alphabet and change each letter in turn using the find & replace function to get everything like this

However I was wondering if there's a quick way to achieve lower case letters, but also to get the first letter only of each Word As A Capitol

Can anyone help me please? And thanks in advance for reading and any help

Hi Guy's,

Thanks for your posts

I tried the PROPER() way, but it was too simple for me as I couldn't get it to work? However.... I also tried the VB code and it worked So I'm well pleased.

I'll have another play with the PROPER() code to try and see why I couldn't get it to work.

Thanks again for your help

hi gents

im trying to learn excel in every way and although i never will
i always try the suggestions on this board to se eif one day they will help me

ive tried this macro and cant get it to run for me

i input my data and then run the macro but nothing happens

why is this