Hi,

I found that all the part ID's in your sample data have length = 10...
So I used the below formula and it worked fine...

=Left(A2,9)

U can also use below formula if u think that there can be part ids which is not 9 digit long...

=Left( A2 , len(A2)-1))