Alphabetizing Method

[Jeff Kocha]

When I export my comics into excel, the book order is different because excel uses different alphabetizing rules for spaces, numbers and special characters.  Is there a way to make it so they both alphabetize the same?

[Steven L. Dasinger]

I don't believe there is a way to easily get a list in the same order outside of CB.
Or at least not directly.
This may or may not help you depending on what you are doing or trying to accomplish (need CB Professional or higher).

CB has a 'hidden' title column called AlphabetizedTitle. This is used by CB to get the Titles in the displayed order.
Instead of using Export, you can run an Advanced Find, then Copy/Paste the result column into Excel (note you still can't use Excel to sort as it will change the order since it won't have AlphabetizedTitle available).

To get a list of all the Comic Book Titles/Issues you own:

Run an Advanced Find with:

WHERE
I.[QtyInStock] >= 1

ORDER BY
ComicTitles.AlphabetizedTitle, I.[ItemType], I.[IssueNum], I.[Variation], I.[Printing]

Select All with CTRL+A
Copy with CTRL+C
In Excel, Paste with CTRL+V

NOTE: If you only want Title and Item #, you can just select those columns by
Click in the first Title cell
Scroll to the bottom and with the SHIFT key pressed and held, click the the last Item # Cell.
Then Copy (from CB) and Paste (to Excel)

If you want more columns, you can either copy all the columns then delete what you don't want from Excel or use menu item Setup->Columns to View to only display the columns you want before selecting all (either with CTRL+A or Selecting the first row/first cell and the last row/last cell with SHIFT pressed and held).

Finally this is just for Comic Books. If you need Books and/or Magazines you would use:

BookTitles.AlphabetizedTitle
MagazineTitles.AlphabetizedTitle

PS You will want to format the Title and Item # columns in Excel as 'TEXT' so they justify correctly.