| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Extrapolate numeric values from text string
Hi,
I need to extrapolate the numeric values from a list of text strings. However, the numeric portion of each string is not consistent from observation to observation. Does anyone have any idea about how to do this in excel. I.e. one observation might be NHY939591C the numeric portion is 939591 PW086877B numeric portion is 086877 AB087623 numeric portion is 087623 Your ideas are much appreciated. Thanks, Henrik |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
| Equation in text string? | Excel Discussion (Misc queries) | |||
| dynamic cell reference within a text string | Excel Worksheet Functions | |||
| How do I LOOKUP text values | Excel Worksheet Functions | |||
| Finding Specific Text in a Text String | Excel Worksheet Functions | |||
Threaded Mode
