Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I combine workbooks, adding new text
I have two key contacts spreadsheets with names, addresses etc, which I now
want to combine, adding one to the other, not overwriting unless the data is the same. Can I do this in Excel? |
#2
|
|||
|
|||
The only build-in functionality that can do this is Data, Filter, Advanced
Filter. This requires that you copy and paste the two lists together to make one list. There should be one row per contact like: Name1 Address1 Name2 Address2 etc. Once you arrange the data this way you can use the above command, selecting the Copy to another location and Unique records only options. Any identical records (all fields being the same) will be listed only once, eliminating duplicates. -- Jim "Peterd35" wrote in message ... |I have two key contacts spreadsheets with names, addresses etc, which I now | want to combine, adding one to the other, not overwriting unless the data is | the same. | Can I do this in Excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a lot of text to MS Excel cells | Excel Discussion (Misc queries) | |||
Adding Two Text Fields together | Excel Discussion (Misc queries) | |||
Adding two text cells together | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Adding Leading Zeros to Text | Excel Discussion (Misc queries) |