I have a very long list of music files and I want to sort bands by name. However, with bands like "The Beatles," I would like to sort these as "Beatles, The."

Is there a formula that will automatically do this?

Thanks!