| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Extract numeric values from an alphanumeric cell based on a criteria
Hi Excel Expert,
I have a list of values in column A of the form: SF 17296CCH CALCIUM CHL 0.35KG 0.77LB SF 17155MMA MALIC 5.442KG 11.998LB in column B for the above examples I would like to get the KG values: 0.35 5.442 Can someone suggest an appropriate formula to achieve this from a range of similar data? Thanks, Hennerby |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using alphanumeric and numeric criteria in same code | Excel Programming | |||
| VLOOKUP with numeric and alphanumeric values | Excel Discussion (Misc queries) | |||
| Need to test for alphanumeric value and write numeric values to ce | Excel Worksheet Functions | |||
| Extract numeric part of alphanumeric cell | Excel Worksheet Functions | |||
| extract numbers from a alphanumeric cell | Excel Worksheet Functions | |||
Threaded Mode
