| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
extracting just numeric value out from alphaneumeric cell
worked like a charm...thx
wrote: So you could use something like this: =VALUE(LEFT(A2,LEN(A2)-2)) Andy. Thanks for the reponse. No not all of them are four character long. They varies from 4 to 7. But they all have MM. [quoted text clipped - 14 lines] =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 OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200603/1 |
| Reply |
| 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 | |||
Hybrid Mode
