In the Find field, use the Insert Special menu to select Carriage Return.It can be tedious because there are many fields.) Repeat steps 3-8 with every field you want to change. If you wish to keep the authors distinct, you may want to experiment with changing the information in a single field at a time. (Note: When a source has multiple authors, this process can cause EndNote to merge the authors' names in an unexpected way. On the Library tab, select Find and Replace. Select all of the references you want to use. Give it a name that will help you remember if it is the edited version or the unedited version. You will want to have an unedited version of Library that you can use later on. We need to make changes to the references that could cause problems with using other parts of EndNote.

Important: Save a Copy of your EndNote Library using the button on the File tab.(Thanks to the Pao Yue-Kong Library at the Hong Kong Polytechnic University for sharing how to clean up the data !) You will need to make changes to get the information in the correct cells in Excel. Many of your references will include characters that interfere with the layout in Excel. First, you need to clean up the information in EndNote.

What is an endnote used for