two ASCII files), then you can open Terminal and type in the command line: If you can copy the two documents to a plain text file each (i.e. Nathan: “ I have two long lists of book titles I need to compare the differences between and see if one list has all of the titles from the second list or is missing any titles.”
Then standardize the columns between the two Excel sheets, and then you can copy and paste the second Excel sheet into the first and then sort by author, title, etc.īy sorting by author you should be able to reconcile the variations between the two lists of publications. Once an Excel sheet is complete you can sort your list of titles by author’s last name, title, etc.ĭo the same for the second list of the books.
I then go into each title and separate each component of the listing by tabs (title, tab, authors last name, tab, authors other name, etc.) Once the entire Word document is formatted you can simply copy and paste the material into an Excel sheet and each component of the list that is separated by a tab will fall into a different column. What I do when I have a problem similar to yours is to block, copy, and paste each list into a Word document using text only paste. If you did, you can sort your sheet by author and title. When you set up your Excel sheets did you set up one column of book titles, one column of authors last name, one column of authors other names, etc.?
0 kommentar(er)
