Hi!
I need to clean up a excel file (2016) with approximatley 2000 records where many of the names and addresses are all caps or all lower case. Is there a forumula I can use to identify these records and change to proper case formating (JOE SMITH, 123 main ave. change to Joe Smith, 123 Main Ave.)?
I need to clean up a excel file (2016) with approximatley 2000 records where many of the names and addresses are all caps or all lower case. Is there a forumula I can use to identify these records and change to proper case formating (JOE SMITH, 123 main ave. change to Joe Smith, 123 Main Ave.)?