Forum Discussion
Extracting Numbers in middle of paragraph
Hey everyone! I am using this formula to extract numbers in the middle of a sentence or paragraph, however, it is only extracting two of my numbers and leaving the third one all zeros. Example...
Your formula creates a number (in words) of 20-sixtrillion. That's a 20 with 21 zeros (Thank you Google). When you display it as a normal number, Excel can handle the first 14 digits and the rest become zeros.
This formula will create a continuous text string of all the numbers in your text:
=TEXTJOIN("",TRUE,IF(ISNUMBER(--MID(A1,ROW($A$1:INDEX($A:$A,LEN(A1))),1)),MID(A1,ROW($A$1:INDEX($A:$A,LEN(A1))),1),""))
Credit for this formula goes to SergeiBaklan. I picked it up a while ago from another topic and used it in my own learning process.