how to split words and find duplicate?

[ajishkumar]

I have a database of 300k and is organized in:

Alex
Alexander robert
robert - karen,

Need to separate it in firstname and second name

After doing this, I need to remove the duplicate email IDs from the excel sheet.

Is there any formula to find and remove duplicates. I am using excel 2007

Thanks for your help.

Ajish
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[wolverineb]

You will need to post some sample data please.

 

[ajishkumar]

it is quite clear from the instruction. I have put three sample names.
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[Krishnakumar]

Hi Ajish,

To separate names, try

In B1:

=LEFT(A1,FIND(" ",TRIM(SUBSTITUTE(A1,"-"," "))&" ")-1)

In C1:

=MID(TRIM(SUBSTITUTE(A1,"-"," ")),FIND(" ",TRIM(SUBSTITUTE(A1,"-"," "))&" ")+1,255)

To findout the duplicates, try COUNTIF

=COUNTIF(eMailRange,eMailID)

HTH

 

[ajishkumar]

thanks kris. let me test it.

<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[ajishkumar]

the excel did not extract the data. The formulas did not work for me.

if anyone has any email Id, i will send the excel file.

Thanks,
Ajish
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[Krishnakumar]

Hi,

Try to post a screen shot of your data.

See guidelines here