Until you recommended using UPPER, I was doing a find/replace
to change to all same case, but this function works like a CHARM!!

Thanks so much, I put the entire formula together in a Macro that does
a few other find/replace actions on other columns in the spreadsheet
and then attached the macro to a toolbar button to be used as
new "messy" files come in.