What can I add to the following formula so that it will take off the last
digit? Because it will always have that zero on the end that I don't want.
Thanks!

As in:
A6: 020605006AA20

=CONCATENATE("", RIGHT(A6,8))
--
Nicki Taylor