Natural Sort (ignore leading articles)


#1

I would like the ability to perform a “natural sort” that ignores leading articles (a, an, the). (I would like grouping to use the same logic.) The use case is that I have a database of books, and I would like “The Adventures of Huckleberry Finn”, for example, to appear in the A’s rather than the T’s. In Google Sheets I achieve this by creating a dedicated sort column with a function: REGEXREPLACE($B2, "^(A|An|The) ", "").