Handy Excel Functions

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