Split email username and domain name in Excel

December 9, 2011 11:42

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?

Share

Comments are closed.