Mid Find

Hi,

I am trying to solve my problem using the Mid Find formula, but it only solves partially of the problem.

Data#1 : id match. for id = 941942 idtype = 101[warning]<DIAGNOSTIC CODE 1000016> for id = 941942 idtype = 101[warning] with additional error text

Data#2 : id match. for id = 11387 idtype = 101[warning]

I was using Mid Find formula to get the id value i.e 941942 and 11387, but I got below instead

941942 and 11387 i

I set the formula as below:
=MID(C514,FIND("= ",C514)+1,8)

Hope any of you can help.

What... You want extract number from a string?

Try this:

=LOOKUP(99^99,--("0"&MID(B8,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},B8&"0123456789")),ROW($1:$10000))))

Thanks so much!!