tnks for the help but i don't get the formula for the valve cos after input

=valve(right(A1,len(A1)-1))

I got #NAME? is there anything that I miss out?

" wrote:

"vcff" wrote:
I need to remove the letter at the beginning of each part number.

=right(A1,len(A1)-1)

That results in text. If you want a number, then:

=value(right(...))