Using parts of other numbers to complete another?????

[DK]

I have 100's of products that have a SKU number for our inventory, and they have to also be assigned UPC codes for selling. Here is the lay out of the 2 numbers.
SKU 1234XXXX the first 4 digits are fixed for all products, and the last 4 are unique each product size, color...

UPC 1234567XXXXY the first 7 digits are the same for all Y is created later.

So I have the SKU's done, what I want to happen is the new UPC cell go pull the 4 digits XXXX from the individual SKU fields and apply them to the new UPC code. Thus making the SKU and UPC the same in the XXXX slots.
I do not know if this can be done but I can not figure it out if anyone can help...

 

[Earl Kiosterud]

DK,

=1234567 & RIGHT(A2,4)

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

I have 100's of products that have a SKU number for our inventory, and

they have to also be assigned UPC codes for selling. Here is the lay out of
the 2 numbers.

SKU 1234XXXX the first 4 digits are fixed for all products, and the last 4

are unique each product size, color...

UPC 1234567XXXXY the first 7 digits are the same for all Y is created later.

So I have the SKU's done, what I want to happen is the new UPC cell go

pull the 4 digits XXXX from the individual SKU fields and apply them to the
new UPC code. Thus making the SKU and UPC the same in the XXXX slots.

I do not know if this can be done but I can not figure it out if anyone

can help...