Card Tricks

Posts Tagged ‘Numbers’

Excel Magic Trick 489: Extract Only Numbers From Text String Array Formula

January 31st, 2010

See an amazing Array Formula from Domenic and Ron Coderre at the Mr Excel Message Board that extracts only the numbers from a text string. See the functions LEN, INDIRECT, ROW, MID, ISNUMBER, INDEX, LARGE, SUMPRODUCT, and SUM.

Tags: array, college, Community, Excel, excelisfun, Extract, formula, FROM, Gel, Girvin, Highline, INDIRECT, ISNUMBER, LARGE, LEN, mid, mike, Numbers, only, ROW, STRING, Sum, SUMPRODUCT, Text