Compare and Populate Approximate Text String

**Kumara_faith** · 02-19-2011, 10:49 PM

Hi,

I have the following in outlet name in sheet 1:

Sheet 1
CBT Mall Concept Houston
CBT Mall Concept Dallas
CBT Concept Train San Diego
CBT Concept Hypermarket Detroit

I need this list to be compared to another list in sheet 2 as follows:

Sheet 2
Concept Mall Dallas
Concept CBT Hypermarket Detroit
CBT Concept Station Train San Diego
Concept Mall Houston

I need a formula to compare both outlet names and populate the approximate match in sheet 1 as attached. Both names are not an exact match.

Is this possible ? Appreciate all the help.

**SDruley** · 02-19-2011, 11:25 PM

You might want to sort your combined lists by city. Then from each city you can define key words, within the entity, that separate one facility from another, e.g., "mall' or "train".
Once key words are identified, they can be the intelligence to create a combined list of unique facilities.

**Kumara_faith** · 02-27-2011, 02:40 AM

Hi,

I have included my actual data. I am from Malaysia, so the city name are often two or three words. I have used text to column but I am not sure how to proceed from here.

Appreciate your help.