if you use this formula =CONCATENATE("",MID(A6,9,8)) then
I hope the length of the numbers is always 9

......!!!!



"NTaylor" wrote:

Thanks... the following worked (just slightly diff from yours)... THanks!
=CONCATENATE("",MID(A6,9,8))
--
Nicki Taylor


"Roger Govier" wrote:

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))