Had you shown us the formula we might have been or more help to you
However, you could try this:
=IF(OR(RIGHT(A1)="B", RIGHT(A1)="K"),"Found a B or a K","not a band")
This will return 1 or 0 depend on the presence of B or K at the end of A1's
text
=SUMPRODUCT(--(RIGHT(A1)={"B","K"}))
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"dan dungan" wrote in message
...
Hi,

In Excel 2000, I'm converting a company's part number to our part
number.

Company part number with band
440HS030NF2107-3B
440HS030NF2107-3K

our part number with band
27140S201440655

Company part number-no band
440HS030NF2107-3

our part number-no band
27140S201410655

The B in the company part number indicates a band.
If, instead of B, the company part number shows K, this also indicates
a band. In both of these cases our part number should have a 4 in the
11th position.

If there is no B or K, that indicates no band and there should be a 1
in the 11th position.

I'm using the following formula to determine if there is a b or k in
the part number. I returns #value. I'm wondering what I'm doing wrong.

Thanks,

Dan