Excel PROPER

Excel PROPER formula properly cases data from all caps to a case sensitive format. But watch out for records like Mr. McWrong as the PROPER formula will change his last name from MCWRONG to Mcwrong. You might have this issue with some address values. But you should be able to review your data after running the formula and find any mistakes.