Formula Required to add on Numbers as required to other data

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

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!

The assumption I am making is that what you show in red above is in cell A1 and SCN0001 is in cell B1, put this in C1
=B1&"-"&RIGHT(A1,2) and copy down, then if needed do a copy >> paste special >> values and paste them over column B

Try

=A1 & "-"&MID(A1,FIND("-",A1)+1,2) and copy down.

You need to make the title of this thread more descriptive so that others can also make use of this solution. Something like "extracting a substring from a code and adding it to the end" would be appropriate.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. I would do this for you if I were completely clear on your objective - please do it yourself.)

Thanks for the title change. Please attach the workbook itself.

OK - please share the solution you found for the benefit of all here.

If you got the assistance from another forum, then please tell us where that was (and read our rules on cross-posting so that you are aware).

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Cross posted at https://www.mrexcel.com/board/thread.../#post-5417657