Formula for Extracting Alphabetic Part of a Product Code

[ob3ron02]

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

 

[Frank Kabel]

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