Hi

Try
=CONCATENATE("", MID(A6,6,7)

Regards

Roger Govier


NTaylor wrote:
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))