| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retreiving only numeric values from a string
There are two parts I am trying to accomplish for a set of data I have in
column A. What I have Results I would like A1:kkdd55dd B1:55 A2:eaa5788ee B2:5788 A3:sfse B3:455 A4: A5: A6:455dae If possible I wanted to have a function where it would Search at a range from A1:A10 and place the first set of numbers it found (always be together) in B1, the second set of numbers it finds placed in B2 and so on. As a reminder I cannot download any type of files if that is to be suggested. -thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TO DELETE ONLY NUMERIC VALUES IN A CHARACTER AND NUMERIC CELL IN | Excel Discussion (Misc queries) | |||
| How do I replace last numeric string from a alphanumeric string? | Excel Discussion (Misc queries) | |||
| Extrapolate numeric values from text string | Excel Worksheet Functions | |||
| Extracting numeric values from string | Excel Worksheet Functions | |||
| Giving the String expression for Numeric Values.... | Excel Programming | |||
Threaded Mode
