i used google sheet : i need function in c2

[dabielcrbyton]

i used google sheet :

a1	b	c	d
a2	2S 5D [AC KH 2S QS JS]
a3
a4

please i have this string in b2
2S 5D [AC KH 2S QS JS]
i need function in c2
to do that :
we can see that before the [ ]
are the sign "2"
i need function that determinant if inside the [ ]
their are also the sign 2
and if so i need it to writing in c2
the sign 2

the same thing i need to do with the sign:
A
K
q
J
10
9
8
7
6
5
4
3


and if the function don't find :
i want it to write "no" in c2

 

[dabielcrbyton]

a1	b	c	d
a2	9 K [9 K J 3 J]	9	[

that what it show in c2
9

it should show
9 k


because 9 and k
show before the [ ]
and also inside the [ ]



as i say my friend
i using google sheet

חישובי פוקר באקסל (אחרי השינוי של הסדרה)

Sheet1 רונאלדו (להכניס נתונים),שלישייה ( היד שלי והקהילתי),שני זוגות ( היד שלי והקהילתי),רביעייה,פלאש ,High Card,זוג אחד,סדרה,האם יש לי פול האוס רביעייה רק עם אחד מהקלפים שלי,רביעייה עם שני הקלפים שלי ,פלאש עם קלף אחד שלי ,פלאש עם שני הקלפים שלי ,המספר הכי גבוה בידיים שלי הוא :,עם קלף אחד שלי...

docs.google.com

with this link you can also edit the sheet

 

[jasonb75]

The formulas were based on the example in post 1, 2S 5D [AC KH 2S QS JS] which includes the suit. Now that you have removed the suits from the string it will not work.

It only needs a very basic edit which you should be able to do yourself if you read the help for the functions that are used in the formula.