From LedHed's Wiki
(Created page with "This page consists of Excel examples that might come in handy. == Extract Only Numbers from a String == =SUMPRODUCT(MID(0&A1,LARGE(INDEX(ISNUMBER(--MID(A1,ROW($1:$25),1))*...") |
(No difference)
|
Latest revision as of 19:39, 25 October 2014
This page consists of Excel examples that might come in handy.
Extract Only Numbers from a String
=SUMPRODUCT(MID(0&A1,LARGE(INDEX(ISNUMBER(--MID(A1,ROW($1:$25),1))* ROW($1:$25),0),ROW($1:$25))+1,1)*10^ROW($1:$25)/10)
Reference: http://www.extendoffice.com/documents/excel/1622-excel-extract-number-from-string.html