Excel Forum
Similar Content
TRIM - Remove Spaces From the Sides of Text and Extra Ones in the Middle in Excel
Tutorial: This allows you to make sure that there are no hidden spaces at the start or end of the te...
Remove Spaces Between Text in Excel
Tutorial: How to remove spaces from the middle of text in Excel.  This includes removing all spaces...
Get the Number(s) Out of a Cell that Contains Both Text and Numbers in Excel - UDF
Macro: This free Excel UDF allows you to get the numbers out of a cell that contain both text...



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.