Forum Discussion
Sorting Movie Titles
Hello, everyone. I am new to the forum and this is my first post. I have an excel file that lists all the movies I currently have (more than 2500 titles). All of the titles are in the first column....
As variant Helper column could be minimized
formula is
=REPLACE( [@Movie],
1,
4*(LEFT( [@Movie], 4) = "The " ) + 2*( LEFT([@Movie], 2) = "A " ),
"" )Here we may sort, filter, etc by this column
As variant we may minimize column with initial name and work with new column as main one.