fuction which search and change letter

[gorky112]

Hey,
I need a function that:
Checks if a word in a cell contains a given letter, e.g.:
If in A1="KcJh3d" there is a K and J and 3, then in B1="HML",
If in A2="9c8h2d" there is a K and J and 3, then in B1="MML".
I have column A and an array. I want zaby in column B to assign values such as HML or MML to column A.

ps I want to group the types of common cards in poker. The column is the possible common cards and HML etc are their groupings. H = high, M = mid, L = low.


Translated with www.DeepL.com/Translator (free version)

 

[GraH]

For version 2013 I can't build a single cell formula.
Would this do?
PS: Textjoin is for versions 2016 and later.

Book1
	A	B	C	D	E	F	G	H	I	J
1
2		1	3	5
3	KcJh3d	H	H	L	HHL	HHL		King	K	H
4	9c8h2d	H	M	L	HML	HML		Queen	Q	H
5								Jack	J	H
6									10	H
7									9	H
8									8	M
9									7	M
10									6	M
11									5	M
12									4	L
13									3	L
14									2	L
15									1	L
Sheet1

Cell Formulas
Range	Formula
B3:D4	B3	=INDEX($J$3:$J$15,MATCH(MID($A3,B$2,1),$I$3:$I$15&"",0))
E3:E4	E3	=CONCATENATE(B3,C3,D3)
F3:F4	F3	=TEXTJOIN("",TRUE,INDEX($J$3:$J$15,MATCH(MID(A3,{1,3,5},1),$I$3:$I$15&"",0)))
I6:I15	I6	=SEQUENCE(10,,10,-1)
Dynamic array formulas.