Hi
try the following array formula:
=LEFT(MID(A1,3,1024),MIN(IF(ISNUMBER(-MID(MID(A1,3,1024),seq,1)),seq)-1
)

--
Regards
Frank Kabel
Frankfurt, Germany


ob3ron02 wrote:
Thanks for your replies! Unfortunetly I'm told the format for the
part #s have now changed... They're similar to before only they will
always be prefixed with two digits and MAY be suffixed with one
letter. So 19ACOV084A is valid part # as i 17FV276. blah not worth
it. the formula i have now (first two digits of the letters) is good
enough for 95% of the cases. Thank you and I'm sorry I wasted your
time!