Alphabetizing / excluding the word "the"

Hey there. I’d like to alphabetize one set of records in a table but would like to write a formula that would exclude the word “the” at the beginning when alphabetizing. (I rather not just format as Title, The.) Any possible way to do this, or no, because this is essentially a sorting issue, not a formula/record-naming issue?

The way you are describing, with a formula to strip “The” from the beginning, should work well. The formula would look something like SUBSTITUTE({Book Title}, "The ", "")

Note the capitalization and space after "The ". This should help ensure it only removes capitalized versions of the word (although it doesn’t really matter since it’s a hidden field), and the space makes sure it doesn’t leave an empty space at the start of the string after removing the word.

Then you would just sort your table by this new field, and then you can hide it if you want. The original Book Title field should still be your primary (first) field.

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.