| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Formula For Extracting Part Numbers
I am using Excel 2010 for Windows.
I have a database of part numbers like this one: 10_32M2A050A002 CYLINDER Please note that there are two blank spaces between "32M2A050A002" and "CYLINDER". I need a formula that will extract each string after the unerscore (_) sign and the two blank spaces. So the end result would be this: 32M2A050A002 Thanks for your help. -- tb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting a Part of a Formula as Text | Excel Programming | |||
| Help Extracting Numbers formula | Excel Discussion (Misc queries) | |||
| Formula for Extracting Alphabetic Part of a Product Code | Excel Worksheet Functions | |||
| Formula for Extracting Alphabetic Part of a Product Code | Excel Worksheet Functions | |||
| Formula for Extracting Alphabetic Part of a Product Code | Excel Worksheet Functions | |||
Threaded Mode
