=MID(A2,FIND("@",A2)+1,FIND(".",A2)-FIND("@",A2)-1) 
=LEFT(A2,FIND("@",A2)-1) 
=RIGHT(A2,LEN(A2)-FIND("@",A2))
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's.
=MID(A2,FIND("@",A2)+1,FIND(".",A2)-FIND("@",A2)-1)
=LEFT(A2,FIND("@",A2)-1)
=RIGHT(A2,LEN(A2)-FIND("@",A2))
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's.
0 Comments