Formula for Extracting Alphabetic Part of a Product Code
 

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!


--
ob3ron02
------------------------------------------------------------------------
ob3ron02's Profile: http://www.excelforum.com/member.php...o&userid=15450
View this thread: http://www.excelforum.com/showthread...hreadid=273584

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!