Data is random and there isn't any patterns.

"Rick Rothstein" wrote:

How regular is your text? By that I mean, does the text you want to remove
**always** follow the letters OEM? If not, in what way can the text to be
removed be identified? I'm guessing it is not always the 4th "word" in as I
would expect other vendor's names to vary. Also, will the text always be
repeated twice (as your example shows) with all following references
removed? In other words, a single example doesn't give us enough information
upon which to decide how to handle your other data... unless you give us
some kind of "rules" about how all your data is structured.

--
Rick (MVP - Excel)


"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