# Formula Required to add on Numbers as required to other data

1. ## 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!

2. ## Re: Help Required

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

3. ## Re: Help Required

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.

4. ## Re: Help Required

Originally Posted by mrice
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.

The data will be posted into column C not B.

The data will have numbers like this

SASC00037-20
SASC00037-22
SASC00037-24
SASC00037-28
SASC00039
SASC00040
SASC00041
SASC00042-16
SASC00042-18
SASC00042-20
SASC00043-16

So some of these below for example do not need the additional add-ons to this

SCN0049
SCN0049
SCN0049
SCN0049
SCN0057
SCN0058
SCN0064
SCN0031
SCN0031
SCN0031
SCN0078

5. ## Re: Help Required

Welcome to the forum.

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.)

6. ## Re: Formula Required to add on Numbers as required to other data

Here is how I ideally need it to look

Attachment 660600

7. ## Re: Formula Required to add on Numbers as required to other data

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

8. ## Re: Formula Required to add on Numbers as required to other data

Hi,

I have worked out with some assistance what I need and it appears to be working ok.

9. ## Re: Formula Required to add on Numbers as required to other data

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).

11. ## Re: Formula Required to add on Numbers as required to other data

Many thanks guys,

Sorry my timing was a factor and I barley had any usable internet access.

I appreciate everyones assistance!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1