How to Import another file Without having Duplicates?

[SinCity]

I have an Excel file that has data in it like this...

FirstName LastName PhoneNumber
mary johnson (909) 404-1242
(continued...)

And then I have another Excel file that is formatted kind of like this...

f_name l_name p_number
john smith 212-777-7144
(continued...)

How can I import one file into the next so that they are one combined list?
I need for the phone number columns to NOT allow duplicates so they would
probaly have to be in the same format I assume. In both files the phone
number column is set to "General" as the type of text.

help!

 

[CLR]

Be sure to practice on a COPY of your data.....

This formula in D1 and copied down, will convert the first type format to
the second...you can then do Copy > PasteSpecial > Values on column D to get
rid of the formulas and then delete the original column C and then do the
import.....

=MID(C1,FIND("(",C1,1)+1,3)&"-"&RIGHT(C1,8)

hth
Vaya con Dios,
Chuck, CABGx3