| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capturing Part Numbers Within Text Strings
I need to capture part numbers that are embedded in text strings.
For instance, the string in A1 is: 9UNI01 05A4462-300202 US1U US1C Standard ....and I am looking for a function (in B1) that will capture the part number, i.e.: 05A4462-300202 The part numbers are always in the second position of a string and separated --right and left of them-- by several blank characters. Thanks. -- tb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help With Searching For Strings In Part Numbers | Excel Worksheet Functions | |||
| Capturing a word sequence as part of a text in a spreadsheet cell | Excel Worksheet Functions | |||
| 2 more questions about extracting numbers from text strings | Excel Discussion (Misc queries) | |||
| Text strings recognized as numbers given different regional settin | Excel Programming | |||
| ADO inserts text strings not numbers when table is empty | Excel Programming | |||
Threaded Mode
