Hi,
I am currently helping someone with an innovatory spreadsheet which is to my horror nearly 15,000 lines long!
Anyhow,
One of the many products codes, are based on the sizes, so for example, i will have a sequence of product codes like this in two columns - one is our code with sizes and the second column is the suppliers code but with no sizes
SASC00001-16 SCN0001-16
SASC00001-18 SCN0001-18
SASC00001-20 SCN0001-20
SASC00001-22 SCN0001-22
SASC00001-24 SCN0001-24
SASC00001-28 SCN0001-28
SASC00002-07 SCN0002-07
SASC00002-16 SCN0002-16
SASC00002-18 SCN0001-18
SASC00002-20 SCN0001-20
SASC00002-22 SCN0001-22
SASC00002-24 SCN0001-24
SASC00002-28 SCN0001-28
SASC00003-07 SCN0003
SASC00003-08 SCN0003
SASC00003-18 SCN0003
SASC00003-20 SCN0003
SASC00003-22 SCN0003
SASC00003-24 SCN0003
SASC00003-28 SCN0003
SASC00004-07 SCN0004
SASC00004-08 SCN0004
SASC00004-18 SCN0004
SASC00004-20 SCN0004
SASC00004-22 SCN0004
SASC00004-24 SCN0004
SASC00004-28 SCN0004
SASC00005-07 SCN0005
SASC00005-08 SCN0005
SASC00005-18 SCN0005
SASC00005-20 SCN0005
SASC00005-22 SCN0005
I basically need to be able to add the last two numbers to each of the product numbers in the second column to match those in the first column.
Is there a way for me to use a formula to help me as there are hundreds like this to complete!
I am currently helping someone with an innovatory spreadsheet which is to my horror nearly 15,000 lines long!
Anyhow,
One of the many products codes, are based on the sizes, so for example, i will have a sequence of product codes like this in two columns - one is our code with sizes and the second column is the suppliers code but with no sizes
SASC00001-16 SCN0001-16
SASC00001-18 SCN0001-18
SASC00001-20 SCN0001-20
SASC00001-22 SCN0001-22
SASC00001-24 SCN0001-24
SASC00001-28 SCN0001-28
SASC00002-07 SCN0002-07
SASC00002-16 SCN0002-16
SASC00002-18 SCN0001-18
SASC00002-20 SCN0001-20
SASC00002-22 SCN0001-22
SASC00002-24 SCN0001-24
SASC00002-28 SCN0001-28
SASC00003-07 SCN0003
SASC00003-08 SCN0003
SASC00003-18 SCN0003
SASC00003-20 SCN0003
SASC00003-22 SCN0003
SASC00003-24 SCN0003
SASC00003-28 SCN0003
SASC00004-07 SCN0004
SASC00004-08 SCN0004
SASC00004-18 SCN0004
SASC00004-20 SCN0004
SASC00004-22 SCN0004
SASC00004-24 SCN0004
SASC00004-28 SCN0004
SASC00005-07 SCN0005
SASC00005-08 SCN0005
SASC00005-18 SCN0005
SASC00005-20 SCN0005
SASC00005-22 SCN0005
I basically need to be able to add the last two numbers to each of the product numbers in the second column to match those in the first column.
Is there a way for me to use a formula to help me as there are hundreds like this to complete!