| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Parsing out text or numbers
I have cells that I would like the string after * parsed out into another
cell. My example of data looks like this. LOT 1 - 2ND WAVE P/N 120168715 * Precihole LOT 1.5 - 2ND WAVE P/N 101249134 * Dualong DEDS-MECH-02 P/N 500-100-005084 * Hudo DEDS-MECH-02 P/N 120158973 * Luaging So I would envision Precihole being in its own cell after the formula has run. And so on. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| parsing text | Excel Discussion (Misc queries) | |||
| Parsing Number from Text | Excel Discussion (Misc queries) | |||
| Parsing text | Excel Discussion (Misc queries) | |||
| Parsing Data with Formulas (vs Text-to-Columns) | Excel Worksheet Functions | |||
| Parsing text in Excel | Excel Worksheet Functions | |||
Threaded Mode
