Does this formula do what you want?

=MOD(SUMPRODUCT(SEARCH(MID(A1,ROW(1:99),1),"012345 6789ABCDEFGHIJKLMNOPQRSTUVWXYZ-.
$/+%") )-99,43)

I think it calculates the MOD43 check number for the text in A1. If you need
the formula to calculate the character equivalent to this number, then try
this formula...

=MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ-.
$/+%",MOD(SUMPRODUCT(SEARCH(MID(A1,ROW(1:99),1),"012 3456789ABCDEFGHIJKLMNOPQRSTUVWXYZ-.
$/+%") )-99,43),1)

--
Rick (MVP - Excel)


"CLI-Art" wrote in message
...
Is there a mod43 check digit calculator in Excel. If not, has anyone out
there made one?