How to Import another file Without having Duplicates?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SinCity - 05 Oct 2006 20:15 GMT

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!

Reply to this Message

CLR - 06 Oct 2006 16:34 GMT

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

> I have an Excel file that has data in it like this...
>
[quoted text clipped - 14 lines]
>
> help!

Reply to this Message