Open Access. Powered by Scholars. Published by Universities.®

Education Commons™

Open Access. Powered by Scholars. Published by Universities.®

Scholarship of Teaching and Learning

PDF

Gardner-Webb University

Series

Excel sorting formula

Articles 1 - 1 of 1

Full-Text Articles in Education

Sorting By Lc Call Number In Excel, Daniel W. Jolley May 2023

Sorting By Lc Call Number In Excel, Daniel W. Jolley

Dover Library Faculty Professional Development Activities

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.

Go to article