Thread: How to separate user name and domain name in email id?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
  
Posts: 2,059
Default How to separate user name and domain name in email id?
On Feb 16, 11:00*pm, Harshad wrote:
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: , 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&"@","")
Reply With QuoteReply With Quote