| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
extracting just numeric value out from alphaneumeric cell
Is there any formula to extract just neumeric value out from a cell which has
both text and a numerial values? for example 10MM, and I just like to extract out 10 in different cell. I have tried left function, but it is specific due to range. So if I put =left(a2, 2), it will spit out 10 but what if the value is 2, or 750. Any help will be appreciated. -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| Extracting last 5 characters from a cell | Excel Discussion (Misc queries) | |||
| Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) | |||
| resolving a numeric cell entry for its meaning | Excel Worksheet Functions | |||
Threaded Mode
