In Excel you could add in column C

=TEXT(A1,"0000000000")&TEXT(B1,"0000000000")