Hi Nicki

From your original example, I assumed you wanted
5066AA2 out of the value in A6, which is what I was trying to achieve.
I also assumed that all of your data was of the same format.
Your solution, must be referring to a much longer string in A6 for it to work.
As pointed out by Excelforeman, the more generalised way would be to look at
the length of the string, and the formula should be (I think, if my
interpretation of what you want is correct), as follows
=CONCATENATE("",MID(A6,LEN(A6)-8,7))
or as Dave rightly points out, you don't need the concatenation so
=MID(A6,LEN(A6)-8,7)

Regards

Roger Govier


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