Excel Forum

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

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.

Got a Question? Ask it Here in the Forum.