Split E-mail Address in Half in Excel

Username: (before '@' sign)

=LEFT(A1,FIND("@",A1)-1)

Domain: (after the '@' sign)

=RIGHT(A1,LEN(A1)-FIND("@",A1)+1)

...the +/- 1 adds or removes the @ symbol