仙台城 – 伊達獨眼龍政宗

How to split email username and domain name to two cells in Excel? Suppose the email address is in A2 cell.

Grab domain name from email
=MID($A2,FIND(“@”,$A2)+1,LEN($A2)-FIND(“@”,$A2)+1)

Grab username name from email
=MID($A2,1,FIND(“@”,$A2)-1)

Easy, right?

Filed under:
Documentation, Excel by Michael Wai