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?
Comments Off
