New
#1
EXCEL sort sequence
Hi there
I'm trying to create a list of Movies in my DB in alphabetical order with folders A,B,C etc.
Is there a way to store for example "The Day the earth Stood Still - 1951" in D ignoring the word "THE" in the sort sequence if it's the first word of the film title. I also don't want to store the title as for example "Day the Earth stood still The"
Should be simple but I can't seem to construct a decent EXCEL formula that does this for me.
Cheers
jimbo