Forum Discussion
Cheryl
Jul 21, 2022Copper Contributor
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...
- Jul 22, 2022
=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.
OliverScheurich
Jul 22, 2022Gold Contributor
=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.
- CherylJul 22, 2022Copper Contributor
OliverScheurich Yes it works!! Thank you so much!!