Hey!

first: excuse my english, I tried my best

I would appreciate any help on the following problem:

In the A columns I have texts which look like this:
A1 "Hand 27s - bet: 30%, check: 70%"
A2 "Hand 98o - bet: 100%
A3 "Hand T7 - call: 88%, raise: 5%, fold: 7%)
etc.

so I have values vor bet, check, call, raise, fold if its > 0%)
in the next columns I want to read the percentages (B,C,D,E,F - bet, check, call, raise, fold)

example for B1 (look for percentage of bet):

=IF(A1<>"";MID(A1;FIND("bet:";A1)+5;FIND("%";A1;FIND("bet:";A1)+5)-(FIND("bet:";A1)+5));"")

explanation:
- it checks if there is any text in the field - it not it does nothing instead of giving "#VALUE!"
- it looks for the position of "bet". +5 is where the percentagenumber starts (check would be +7, fold +6 and so on)
-after that it figures out the length by looking for the "%" after "bet" and subtracting the position of "bet" from the position of the % after "bet"

problem: when FIND doesn't find the text it gives out #VALUE! for the field.
I've heard that ISTEXT oder ISNUMBER might work, but I don't know how to implement that in my formula.