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




About this tutorial:

Video duration: 8:12
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.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

Leave a Reply

Your email address will not be published. Required fields are marked *

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




About this tutorial:

Video duration: 8:12
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.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

Leave a Reply

Your email address will not be published. Required fields are marked *