From LedHed's Wiki
Revision as of 19:39, 25 October 2014 by Ledhed (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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

Retrieved from "http://wiki.ledhed.net/index.php?title=Handy_Excel_Functions&oldid=3129"