I have a list of addresses that I get sent from an external source in Excel and the list has some duplicates in it which I need to remove.
For example and entry might be : J Bloggs 1 any street Any Town London Town London Town (the duplicate being London Town)
I have a macro that can remove single word duplicates, ie: London London, but I need one that will remove duplicates of more than one word as in the example above.
The duplicates always occur next to each other so the cell won't start London Town with text inbetween the duplicate entries.
Does anyone know whether there is a macro/UDF that I could use to remove these entries ?
Ordinarily I would go back to the source and ask them to stop duplicating the entry however this will take weeks as it's an external company.
Any help greatly appreciated.
Euan
For example and entry might be : J Bloggs 1 any street Any Town London Town London Town (the duplicate being London Town)
I have a macro that can remove single word duplicates, ie: London London, but I need one that will remove duplicates of more than one word as in the example above.
The duplicates always occur next to each other so the cell won't start London Town with text inbetween the duplicate entries.
Does anyone know whether there is a macro/UDF that I could use to remove these entries ?
Ordinarily I would go back to the source and ask them to stop duplicating the entry however this will take weeks as it's an external company.
Any help greatly appreciated.
Euan