Sorting and skipping "The"

[Joel_D_Eon]

Hello,
Is there a way to sort by name, but ignore “The” in the sort calculation. I am trying to sort albums with a Artist + Album field and would like the sorting to ignore “The” in the artist name.

[Bill_French]

Hi Joel, and welcome to the community!

Joel_D_Eon:

Is there a way to sort by name, but ignore “The” in the sort calculation?

Yes, briefly…

1. Create a new formula field that eliminates your stop-words (i.e., the and maybe others).
2. Sort on the formula field.

[Joel_D_Eon · Accepted solution]

Thank You. I used the Substitute formula and that worked