Extract numeric value from X Point until next non numeric values

[PHIL.Pearce84]

Hi,

I'm in need of help I have identified when the first numeric value appears in a cell, what I am now trying to do is extract all numeric values from this point until the next non numeric value, the length of which can vary.

And I'm completely stump!

Sample table below:

Original Data	1st Numeric Value Point	Desired Result
Testing Data 67860Test	14	67860
Test123 The Test Street	4	123

 

[RoryA]

Can you update your profile to indicate which version of Excel you have? It will make a big difference to the possible solutions.

 

[PHIL.Pearce84]

Can you update your profile to indicate which version of Excel you have? It will make a big difference to the possible solutions.

Hi,

Will do that now, Im using office 365 Excel version 2312 if that helps?

 

[RoryA]

Thanks. Here's one way:

=TEXTJOIN("",TRUE,IFERROR(--MID(A2,SEQUENCE(LEN(A2)),1),""))

 

[kvsrinivasamurthy]

Try in C2 copied down.

=LET(a,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"01234567890")),b,MAX(IFERROR(1*MID(A2,a,SEQUENCE(LEN(A2)-a+1,1)),0)),IFERROR(1/(1/b),""))