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.