M
mccloud
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
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