Within my 'Name' field, often titles will appear as:
The Four Aces - Written On The Wind
Wally Lewis - Kathleen
whereas I wish them to present with title firstly, as in
Written On The Wind - The Four Aces
Kathleen - Wally Lewis
Can anyone please guide me with a formula to apply (and where?), to achieve my preferred order within the 'Name' field?