How to combine these 11 cells into one cell for upc formula?

[Rocky2889]

Currently I am using this formula for UPC code generating. But the problem is I have all digit 11 cells. Is there anyway to combine into cell. Here is the formula.

=MOD(10-(MOD(((A1+C1+E1+G1+I1+K1)*3)+(B1+D1+F1+H1+J1),10)),10)

Thanks

Rocky

 

[sweater_vests_rock]

Not sure if the last post will depict the image properly.

So:

Cell A1 (User Input): 268268-12345

Cell C1 (Calculated): =MOD(10-(MOD(((MID(A1,1,1)+MID(A1,3,1)+MID(A1,5,1)+MID(A1,8,1)+MID(A1,10,1)+MID(A1,12,1))*3)+(MID(A1,2,1)+MID(A1,4,1)+MID(A1,6,1)+MID(A1,9,1)+MID(A1,11,1)),10)),10)

Cell E1 (Calculated): =REPLACE(A1,7,1,"")&C1

 

[Rocky2889]

Ben,

Thanks for your help.

Rocky