this is not removing duplicate rows, but duplicates within a text string

its complex.
1) identify the 'code' you can use
MID( text, instrRev(text," ")+1)
this finds the first space from the end - assumes that the last piece of
text will be the code

2) count how many times the code appears in the text
3) replace all but the first and last code's with nulls

your example seems to have 3 codes still



"mccloud" wrote in message
...
I've got a spreadsheet with a description colunm. The current
descriptions
have repeated partnumbers over and over throught the row. Is there
something
I can use to leave the first two entries (left - right) and remove the
rest.
Each row has a different part number duplicated. Example - HEWLETT
PACKARD
OEM Q2624A HP - Toner Cartridges for HP LaserJet 1150 - Q2624A, Black,
2500,
Print Cartridge, Model No. Q2624A NEW OEM HP LaserJet 1150 Series Q2624A
HEWQ2624A Q2624A. I need it to look like this... HEWLETT PACKARD OEM
Q2624A
HP - Toner Cartridges for HP LaserJet 1150 - Q2624A Black, 2500, Print
Cartridge, Model No. NEW OEM HP LaserJet 1150 Series HEWQ2624A.

Is this possible in Excel or Access?

Thanks