| 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 |
| 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 | |||
Threaded Mode
