Convert first letter of every word to Uppercase . Not Proper casing

I use proper function to convert words to proper case but when entering addresses like GPO Box 123 , USA etc...
the GPO part and the USA part needs to remain in capital format, my goal is simply to make every first letter of the word uppercase irrespective of what the casing of following letters it. is there any way to achieve this ? there are more than just
GPO there are other words that also need to be all in capitals which appear in capitals already and have to remain in capitals.


For example :

the contents of cell before macro

"THE UNITED STATES OF AMERICA is a warm country"

The desired result after the macro should be

"THE UNITED STATES OF AMERICA Is A Warm Country"




I want this macro to run on the whole Column E .

Thanks in advance !!

Please Login or Register  to view this content.

Originally Posted by AB33

Please Login or Register  to view this content.

This code would propercase the whole sentence . so if i have a word USA in the cell that would become Usa and i dont want it to happen :-)

Originally Posted by jindon

Please Login or Register  to view this content.

Edit:

Thanks Jindon .. can you just convert it into a sub ( a macro code for column E which i can execute )

Please do not reply with full quote, just a reply will do. It has not purpose other than to clutter the space of this page.
I can only go by your example.


"THE UNITED STATES OF AMERICA Is A Warm Country" is converted in to
"THE UNITED STATES OF AMERICA Is A Warm Country"

See my post again.

Thanks a lot ... served my purpose .. Take my like and reputation .