CODEWITHSUNDEEP
excel-formula
user4637238
user4637238

Reputation: 77

Extract a portion of a string using excel formula

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)

Upvotes: 0

Views: 65

Answers (1)

user4637238
user4637238

Reputation: 77

This seems to work

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

Upvotes: 1

Related Questions