Excel Forum



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.





Got a Question? Ask it Here in the Forum.