Document Type

Presentation

Publication Date

5-24-2023

Abstract

Sorting by Library of Congress (LC) call number in Excel is problematic because Excel does not treat LC call numbers as numbers. In practice, this means that Excel sorts LC call numbers based on each successive digit in the call number rather than the overall value of each call number. (for example, a call number beginning with PS507 would be sorted after one beginning with PS4998 in a default Excel sort). In this presentation, I demonstrate one method for accurately sorting by LC call number in Excel.

Comments

Delivered at the North Carolina WMS User Group meeting at Salem College in Winston-Salem, North Carolina, on May 24, 2023.

Download

Share

COinS