| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a formula in excel where part remains absolute the . | Excel Discussion (Misc queries) | |||
| Bold part of formula results | Excel Discussion (Misc queries) | |||
| What instead of an array formula part 2 | Excel Discussion (Misc queries) | |||
| my computor crashed and I lost my product code to reinstall how c. | Excel Discussion (Misc queries) | |||
| Formula for Extracting Alphabetic Part of a Product Code | Excel Worksheet Functions | |||
Linear Mode
