extracting text around the @ symbol

[KFB]

I have been sent multiple pieces of data all in one field. How can I extract
the text surrounding the @?

 

[Gary''s Student]

You can use Text to Columns to separate the data into individual cells using
the @ as a separator.

 

[Mike H]

Try,

=LEFT(A1,(FIND("@",A1,1)-1))&MID(A1,FIND("@",A1,1)+1,999)

Mike

 

[Teethless mama]

=SUBSTITUTE(A1,"@","")