I often get lists of businesses and need to compare them against our existing customer list. We may have ABC Widget Company in our list, and the new list could have ABC Widget Co. or just ABC Widget. Is there a way to compare text in a cell and return a true/false value if the text in those cells are close but not exact?
My only other idea is to create a LEFT function for each cell for 5 or so characters and compare "ABC W" to "ABC W". This may work in most cases but won't work with "The Widget Co" vs. "Widget Company, The".
My only other idea is to create a LEFT function for each cell for 5 or so characters and compare "ABC W" to "ABC W". This may work in most cases but won't work with "The Widget Co" vs. "Widget Company, The".