Change to one description

Switch

New Member
Joined
Nov 10, 2002
Messages
7
Hi

In this worksheet product description are downloaded from a custom sales information system. I want to go to each column and change the description to be the same as the one in column D. The only common denominator is the last 5 digits. An example of this is the description in A2 should be the same os the one in D11. This new description can appear in a column inserted after each column.

Please can anyone help. I am new to this forum and most impressed with the help I have received. Great job guys!!
Test.xls
ABCD
1QANTEL01/02QANTEL2003WASALESSALESACTUALS01/02(exclWA)SALES2003(exclWA)
29303002-CELLIODCHART9301707-LYPRINOLPRACTITIONER(50)AntioxidantPlus(60)_03630AntioxidantPlus(60)_03630
39303023-CELLOIDSP96(84)9303002-CELLIODCHARTAvenaComplex(42)_03346AvenaComplex(42)_03346
49303024-CELLOIDSS69(84)9303023-CELLOIDSP96(84)BioC-Complex1000(60)_03624BioC-Complex1000(60)_03624
59303025-CELLOIDCP57(84)9303024-CELLOIDSS69(84)Bio-CComplex125g_03606Bio-CComplex125g_03606
69303026-CELLOIDIP82(84)9303025-CELLOIDCP57(84)Bio-ChromiumPlus(60)_03633Bio-ChromiumPlus(60)_03633
79303027-CELLOIDPP85(84)9303026-CELLOIDIP82(84)Bio-Disc(60)_03634Bio-Disc(60)_03634
89303028-CELLOIDMP65(84)9303027-CELLOIDPP85(84)Bio-IronPlus(90)_03625Bio-IronPlus(90)_03625
99303029-CELLOIDS79(84)9303028-CELLOIDMP65(84)Bio-MineralFormula(60)_03640Bio-MineralFormula(60)_03640
109303030-CELLOIDPC73(84)9303029-CELLOIDS79(84)Bio-Tocopherol250IU(60)_03627Bio-Tocopherol250IU(60)_03627
119303031-CELLOIDCS36(84)9303030-CELLOIDPC73(84)CelloidChart_03002CelloidChart_03002
129303032-CELLOIDPS29(84)9303031-CELLOIDCS36(84)CelloidPrescribersRef_03932CelloidPrescribersRef_03932
139303033-CELLOIDCF43(84)9303032-CELLOIDPS29(84)CF43(84)_03033CF43(84)_03033
Sheet1
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
L

Legacy 98055

Guest
Hi Switch

Please check and see if this is the correct result taken from your example in cells A3:A5

CELLOID SP96 (84)_03023
CELLOID SS69 (84)_03024
CELLOID CP57 (84)_03025

tom
 

Switch

New Member
Joined
Nov 10, 2002
Messages
7
On 2002-11-12 01:53, TsTom wrote:
Hi Switch

Please check and see if this is the correct result taken from your example in cells A3:A5

CELLOID SP96 (84)_03023
CELLOID SS69 (84)_03024
CELLOID CP57 (84)_03025

tom

Tom,

What I am trying to achive is that when the 5 digit number is the same that the description is changes to a uniform description. As this information comes from a sales system and different areas have different descriptions, I have to first get it to describe each product code the same.

Hope this makes sense. I have email you the whole file.

Thanks
Switch
 

Watch MrExcel Video

Forum statistics

Threads
1,122,822
Messages
5,598,307
Members
414,224
Latest member
Crazy_FC

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top