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