Forum Discussion

Cheryl's avatar
Cheryl
Copper Contributor
Jul 21, 2022
Solved

How to extract the bigger number from the first bracket?

Hi!   May I ask if it's possible to get the expected result below? Unsure if I should use regexextract. I can get a number but not the expected one.   Here's the screenshot Here's the link...
  • OliverScheurich's avatar
    Jul 22, 2022

    Cheryl 

    =IFERROR(TRIM(MID(A2,SEARCH("[0-",A2)+3,FIND(" Booking]",A2,SEARCH("[0-",A2)+3)-(SEARCH("[0-",A2)+3)-5)),0)

    Maybe with this formula.