| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract DAta from text
Hi,
Not sure what format you want, but if the part number is in E10, This formula in a cell will return the digits that follow CH: =IF(ISNUMBER(MID(E10,3,2)*1),MID(E10,3,2),MID(E10, 3,1)) and this next formula in another cell will return the digits that follow R =IF(ISNUMBER(RIGHT(E10,2)*1),RIGHT(E10,2),RIGHT(E1 0,1)) Hope this is helpful Regards - Dave. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to extract certain text from text string | Excel Worksheet Functions | |||
| Extract text from large Text | Excel Discussion (Misc queries) | |||
| Text Extract | Excel Worksheet Functions | |||
| EXTRACT TEXT FROM TEXT STRING | Excel Worksheet Functions | |||
| Search/Extract Data w/in Text File | Excel Discussion (Misc queries) | |||
Hybrid Mode
