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
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.
yes Gmail , yahoo, hot mail also considered as personal
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.comWith 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.
excellent thank u very much
it is is best solution to my problem thank u...