Thank you for the suggestion. This did separate information into columns, but
the result was unfortunately still unusable. The information was not broken
out in a usable format. Each column had different information by row. (For
instance, in one of the new spreadsheet, the last name of the person is
listed, but the next row down in the same column, the last name is followed
by part, but not all, of the company name.) I tried using different
delimiters (tab, space, etc.) with the same type of results. Any additional
thoughts?
"Luther" wrote:
> You can import the CSV into Excel. Then in Excel, select the first
> cell-column, use menu Data|Text to Columns to convert the columns to
> excel cells. In the BCM generated CSV file the columns are
> comma-separated.
>
>
|