hi,

check the length of the part # in column..

=len(a1)
=len(a1)
...
...


U will get the answer