| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract just numeric part of mixed text/number entry?
I've got a column of values like AB2.5 and CG24.3 (this is automatically
generated by a machine and I can't change it). I want to extract just the numeric part (2.5 or 24.3) and have Excel treat it as a number. The letters and numbers are variable in length, so I can't just use LEFT, RIGHT and LEN statements to trim the first/last few characters out. Any ideas? Thank you! Heidi |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I work with part of a cell entry? | Excel Worksheet Functions | |||
| Extract Part of String | Excel Worksheet Functions | |||
| Summing part of an Alpha Numeric String | Excel Worksheet Functions | |||
| Part Number/Qty Consolidations | Excel Discussion (Misc queries) | |||
| vlookup to extract part cell content | Excel Discussion (Misc queries) | |||
Threaded Mode
