Deleting Duplicated Text 1

[APElliott]

Hello,

I have a Excel column with page and item refs ie 02/03/A.

On occasions the same reference is duplicated or more.

Can anyone advise of a code that will delete all but the first of these references.

 

[xlbo]

check this link out:

http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicates

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244

 

[APElliott]

Cheers Geoff,

Not tried it yet, but it looks good to me.

Thanks,

Andrew