Lee,

BIAB is doing everything correctly, what you are experiencing is a Microsoft quirk and due to how Excel is interpreting the information.

Firstly...

Make sure that you only have "Tab" selected when asked about the delimiter when pasting into Excel. It looks like you might have multiple delimiters presently selected; maybe "Tab" as well as space and/or comma. (The delimiter is what identifies each cell's data. The BIAB list is Tab-delimited.)



Secondly...

If you look at the image below, you can see how the "#Name?" issue 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 it is a formula.



This is easily fixed.

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.



Performing the above should correct everything for you. Let me know how you go.

Regards,
Noel

Last edited by Noel96; 06/26/16 04:49 AM.
MY SONGS...
Audiophile BIAB 2024