How to separate user name and domain name in email id?

  • Thread starter Thread starter Harshad
  • Start date Start date
H

Harshad

I have many mail ids in excell sheet in column A. I want to separate the
username and domain name in Column B and Column C respectively. e.g. Column
A: (e-mail address removed), Column B: abcde and Column C: gmail.com


thanks in advance

Harshad
 
I have many mail ids in excell sheet in column A.
I want to separate the username and domain name in
Column B and Column C respectively. e.g. Column
A: (e-mail address removed), Column B: abcde and Column C:
gmail.com
Click to expand...

Several ways to do this. One way ....

If A1 is text of the form "username@domainname", then:

B1: =left(A1,find("@",A1)-1)

C1: =substitute(A1,B1&"@","")
 
Back
Top