Try to add more spaces into text cell (i.e : 7) to get unique text with at least 7 spaces:

=LEFT(A1,FIND("@@",SUBSTITUTE(A1&REPT(" ",7)," ","@@",7),1)-1)