i don't understand I just checked the file again and the formulas are there. I was only trying to help you because I thought it was something on your computer.
this is formula 1
=TRIM(LEFT(A2,FIND("@",SUBSTITUTE(TRIM(A2)," ","@",(LEN(TRIM(A2))-LEN(SUBSTITUTE(TRIM(A2)," ","")))/LEN(" ")))))
based on your example sheet, paste this in cell E2.
here is formula 2
=IF(ISNA(VLOOKUP(E2&"*",B:B,1,0)),"Not in B","")
based on your sample file paste this in cell F2
then once those 2 formulas are pasted, you can copy and paste them to all of the other cells in the E and F columns that you need to do this
select cell E2, and copy
then hilight all of the cells in the E column that you want to paste the formula into and paste
do the same thing for the F column.