Solved i want separate official & personal email ids in excel sheet

Tags:
excel
database
email
April 21, 2013 at 08:09:07
Specs: Windows 7
separation into offical and personal
Hi,
I am using Excel to main my database which contains email ids combination of official (*@company.com) and personals (*@gmail.com).i want to spate these data into as official and personal

See More: i want separate official & personal email ids in excel sheet

Report •

#1
April 21, 2013 at 14:40:29
✔ Best Answer
Is gmail.com the only personal domain you need to be concerned with or are there yahoo, hotmail, etc. addresses also?

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


Report •

#2
April 22, 2013 at 03:48:44
yes Gmail , yahoo, hot mail also considered as personal

Report •

#3
April 22, 2013 at 06:58:12
I would create a list of all of the personal email domains and use the MATCH function to compare the domain of the email address against that list.

e.g. Put this in D1:D3:

        D
1   gmail.com
2   hotmail.com
3   yahoo.com

With your email addresses in A1:A3, enter this in B1:

=IF(ISNA(MATCH(MID(A1,FIND("@",A1)+1,LEN(A1)),$D$1:$D$3,0)),A1,"")

Enter this in C1:

=IF(ISNA(MATCH(MID(A1,FIND("@",A1)+1,LEN(A1)),$D$1:$D$3,0)),"",A1)

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


Report •

Related Solutions
See More ↓

#4
April 22, 2013 at 08:36:43
excellent thank u very much

Report •

#5
April 28, 2013 at 10:34:18
it is is best solution to my problem thank u...

Report •
Start a discussion

Ask Question