Main Profile

At A Glance

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

Contact

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

Want more info about Excel Magic Trick 531: Extract Numbers from Middle of Text String BB34G to 34 (2 methods)? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question