Specific PROPER IF formula

Please help!!

I want to make all cells in a column PROPER(), except when there are UPPER and LOWER case characters in a Cell.

i.e. if the cell contains;

ABC Angola it will return ABC Angola
ABC ANGOLA it will return Abc Angola
Abc Angola it will return Abc Angola

I need to re write several hundred companies and this general rule will tidy them up!

Appreciate your time!

The EXACT function is case-sensitive, so you could try this:

Formula:

Please Login or Register  to view this content.

Awesome, thanks very much.