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

[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

 

[joeu2004]

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

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&"@","")

 

[Harshad]

Dear all,

All of your attampt is working very nicely.

Thanks

Harshad