Mid function for a combination of two cell.

[tonnerre2000]

Hi, good morning, I am trying to find a way to combine to cell and use this funciton.

=D2 & MOD(10 - MOD( SUMPRODUCT(MID(D2, {1,2,3,4,5,6,7,8,9,10,11}, 1) * {3,1,3,1,3,1,3,1,3,1,3}), 10), 10)

it works fine when I write manually D2 for the 11 digits, but D2=B2&C2, a 11 digit number, but the function in E2 = #Value!

Thank you for your help.

Remi

[martindwilson]

ok let's guess what it's supposed to be doing