Extract "The" from a company name for alphabetization

[Federico_Stefanato]

Hi @Kelly_Claus ,
I asked for access to your doc.

In the meantime, you might find something that could go very closer to your needs with this:

[Trick] Templates and placeholders

Hi all, Although Format() formula works incredibly well, sometimes it’s hard to remember the exact sequence of variables. For this reason, I just published a (playground) Doc that provides more flexibility in term of variables (or placeholders) substitution. Please, have a look at Variables Substitution It allows to enter named variables defined elsewhere and to replace the text accordingly. The underlying explanation might be a bit complicated, but I’d be happy to enter into the detail and…

Feel free to ask if you have any question.