Hello

Any functions to match at least some character in b1 to c1 and display it on d1?

like

b1 is clarice Leonie lee

c1 is clarice_lee @abc.com (without space)

d1 is Yes

OR
b1 is clarice Leonie lee

c1 is Carry_lee @abc.com (without space)
d1 is no