 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2004How To Join Two Files & Sort
My first time using Excel - grateful for help. I have two files of names/addresses, mailing lists. I need to join these two files together so I can then sort them and remove duplicate names. How do I join/insert/merge two Excel files, please? Thank you. Bright Spark Hi Bright Spark for all things "duplicates" check out http://www.cpearson.com/excel/duplicat.htm I think you'll find everything you need there, however feel free to post back if you require further assistance Cheers JulieD > My first time using Excel - grateful for help. > [quoted text clipped - 5 lines] > > Bright Spark Thanks, Julie - that will be helpful! But to begin with I need to join the two lists together and I can't seem to do that! I have tried "insert" but it doesn't give me an option to insert a "file" ! Bright Spark >Hi Bright Spark > [quoted text clipped - 16 lines] >> >> Bright Spark Hi Bright Spark if the total combined number of records is less than 65,536 you can simply copy & paste one list onto the bottom of the other. open both workbooks ... If you have version 2002 / 2003 - click in one cell in your list and do control & A (if you have ver 2000 or 97, click on the first cell in the range press control / shift & end) - this should just select the used range, now click edit / copy ... switch to the other workbook (window / choose it from the list), click in the first cell, press the end key & then the down arrow key, this should get you to the end of the data range, click in the first blank cell & paste ... all your records should now be combined. Hope this helps Cheers JulieD > Thanks, Julie - that will be helpful! > [quoted text clipped - 24 lines] >>> >>> Bright Spark Oh - copy and paste! Duh! Thanks, Julie! :o)) Bright Spark >Hi Bright Spark > [quoted text clipped - 42 lines] >>>> >>>> Bright Spark Hi glad to assist ... :) Cheers JulieD > Oh - copy and paste! Duh! Thanks, Julie! :o)) > [quoted text clipped - 47 lines] >>>>> >>>>> Bright Spark |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.