The "Copy List" button is used to export a list of styles into a format that is readable by Excel. Once exported, these data open in Notepad. From there CTRL+A and then CTRL+C will copy all the data to the clipboard and it can be pasted (CTRL+V) directly into Excel.
So that the data is interpreted properly, the following needs to occur.
Firstly...
Make sure that you only have "Tab" selected when asked about the delimiter/separator. Excel doesn't always make the best choice and it seems to also select other delimiters like space and/or comma. (The delimiter is what identifies each cell's data. The BIAB list is Tab-delimited.)
Secondly...
Once the data are pasted, scrolling down Column A will show a number entries that read "#Name?". This occurs with every style that begins with a "=". (See the original name in the formula bar.) This is because Excel uses the equals sign to indicate that what follows is a formula.
To correct this...
1. Click on the "A" column header to select column A.
2. Press CTRL+F to open Find/Replace.
3. In the 'Find' box type in =
4. In the 'Replace' box type in '=
The single quotation mark is used by Excel to say "interpret what follows as ordinary text." This character is found beneath the " character. It is not the character that is found beneath the "~" character.5. Select "Replace all"
While the image below is using OpenOffice, the principle is the same in Excel.
This will correct the "#NAME?" issue.
Lastly, if the paste doesn't seem to work properly...
If Excel assumes full control during the pasting process so that you cannot select Tab as the only delimiter. Try saving the Notepad file as a .txt file. Then open the .txt file in Excel.
Regards,
Noel