| Home |
| Search |
| Today's Posts |
|
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula to extract a numeric value from a free-format tex
I'm not sure what you mean by "numbers that are part of other strings".
I thought that's what was wanted but i'm probably missing something. As Rick states the requirements are not clear enough on this. "Ron Rosenfeld" wrote: On Sat, 18 Jul 2009 02:26:01 -0700, Lori wrote: After further investigations, i think i've got a simplified version: =LOOKUP(1E8,--(MID(A4&".",COLUMN(A:IV),7)&" 0/1")) which returns the last 7 digit integer and errors if none is found. [&" 0/1" ensures only integers are returned; &"e0" would return decimals too] It also returns seven digit numbers that are part of other strings, including longer strings of digits. --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find text in free-format text field | Excel Discussion (Misc queries) | |||
| Extract just numeric part of mixed text/number entry? | Excel Worksheet Functions | |||
| only extract numeric value from alpha numeric cell | Excel Discussion (Misc queries) | |||
| Change number (in text format) to numeric format | Excel Discussion (Misc queries) | |||
| Everytime I need to format cells or text, Excel 2003 takes a lot of time or free | Excel Discussion (Misc queries) | |||
Threaded Mode
