Ledhed: 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))*..."

2014-10-25T19:39:53Z

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))*..."

New page

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

[[Category:Excel]]

Handy Excel Functions - Revision history

Ledhed: 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))*..."