Excel Forum
Similar Content
Partial Match Lookup with Numbers in Excel
Tutorial: Perform lookups on numbers with partial matches. For instance, find the first number that...
Sum Values that Equal 1 of Many Conditions across Multiple Columns in Excel
Tutorial: How to Sum values using an OR condition across multiple columns, including using OR with ...
Extract a Word from a Sentence / Cell in Excel with this UDF - Allows for a User-Defined Delimiter
Macro: Extract whole words from a cell or sentence in Excel with this UDF. This allows you to spe...



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.