### Excel Magic Trick 531: Extract Numbers from Middle of Text String BB34G to 34 (2 methods)

See two formulas that will remove leading and trailing letters in order to extract a number. BB34G becomes 34. See the functions, INDIRECT, ROW, LEN, ISNUMBER, MATCH, MID, COUNT, MATCH. See 1 array formula and one non-array formula.

Length:
08:12