Posted to microsoft.public.excel.programming
|
|
extracting numerics from literal strings
"Tom Ogilvy" wrote...
Array enter (ctlr+Shift+enter rather than just enter in B1)
=MID(A1,SMALL(IF(ISERROR(MID(A1,ROW(INDIRECT("1:" &LEN(A1))),1)*1),"",
ROW(INDIRECT("1:"&LEN(A1)))),1),LARGE(IF(ISERROR( MID(A1,ROW(
INDIRECT("1:"&LEN(A1))),1)*1),"",ROW(INDIRECT("1: "&LEN(A1)))),1)
-SMALL(IF(ISERROR(MID(A1,ROW(INDIRECT("1:"&LEN(A1)) ),1)*1),"",
ROW(INDIRECT("1:"&LEN(A1)))),1)+1)*1
is one way, but I am sure there is a better way.
....
Alternatives,
http://groups.google.com/groups?thre...ws.indigo. ie
|