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....
=SORTBY(C3:C8,E3:E8)You can try the above formula in cell G3 along with a helper formula:
=IF(LEFT(C3,4)="The ",TRIM(MID(C3,4,LEN(C3)-3)&", the"),C3)This formula is in cell E3 and filled down to E8 in the example.
This could be a solution if you work with Office365 or 2021 or Excel online.