Extract a portion of a string using excel formula

Question

I need to extract the central number in the string below using an excel formula

Min { {r4} , {r7} , {r10}}<={r3}<= Max {{r4} , {r7} , {r10}}

here it would be 3. The string is dynamic e.g:

Min { {r4011} , {r4012}}<={r4010}<= Max {{r4011} , {r4012}}

Needs to be catered for also (here i need 4010)

I'm trying combinations of FIND, LEN, RIGHT, but just not getting it so far. — user4637238
– user4637238, Commented May 17, 2016 at 10:39

user4637238 · Accepted Answer · 2016-05-17 11:22:00Z

1

This seems to work

=MID(D1755,FIND("<=",D1755,1)+4,FIND("}<= Max",D1755,1) - (FIND("<=",D1755,1)+4))

answered May 17, 2016 at 11:22

user4637238

771 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1