Quote:
I tried a similar idea to your Find and Replace. I used, Find "=", and replace it with nothing. All the #NAME errors disappeared. Thanks for that. I just need to understand more about the delimiter. I know what it is, but how do I set it without the appearance of a dialog box? Thanks again.


Lee,

Rather than replace the = with nothing, it would be better to replace it with '= as suggested above because the style in BIAB actually begins with the = symbol. This symbol indicates that that the style is a mixture of Realtracks and midi. Styles that have 'nothing' leading the name are midi-only styles. (A leading ' character will not be visible in a cell.)

In relation to the delimiters...

1. Save the file in Notepad as a .txt file.

2. Open Excel and navigate to the saved file and open it. As far as I'm aware, Excel interprets .txt files as tab-delimited.

Here's an article that seems to support my understanding.

http://www.ehow.com/how_12014808_open-tab-delimited-files-excel.html

Regards,
Noel

P.S. It wasn't clear in my original article (now corrected) but the time to choose delimiters is when pasting into Excel. The tab-delimited text is already set in place when leaving BIAB and cannot be changed.

MY SONGS...
Audiophile BIAB 2024