Solved I Need to Separate email id and Domain

April 20, 2013 at 10:44:34
Specs: Windows 7
what I mean is i have company domain and personal mail ids *@gmail.com and *@company.com .. I want to separate these two. Hope you got me

See More: I Need to Separate email id and Domain

Report •


#1
April 20, 2013 at 14:06:11
✔ Best Answer
Please don't try to fit your entire post into the subject line. I have edited your subject line to make it a bit more readable.

With this in A1...

email_id@gmail.com

These 2 formulas will return email_id and gmail.com

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

=MID(A1,FIND("@",A1)+1,LEN(A1))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question