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 !!