Quote Originally Posted by Crasher151178 View Post
I did it like you said but by changing the numbers in words (1 --> one) didn't do the trick so I tried it with adding zero's and that worked just fine.
If you wanted titles starting with a number to be sorted in their corresponded place (that is, 8 Miles in the E) then that was the way... if you want titles starting with numbers stay the first, then yes, don't replace numbers and fulfill with 0's on the left, as many 0's to equal the longer number length.

Is there a way to autocopy the newly typed title from the colum with title to the help column where I have to change the digit's....
Why not use Ctrl+C and Ctrl+V? The solution you want can be made with a sheet event, but it requires to save the book as an .xlsm, that is, macro enabled. But honestly, if you are not very sure about VBA, don't mess with it for such a thing... It only would be worthy if you were adding a lot of titles everyday, and the time saving wouldn't be that great anyway: you can add all the titles first, and then just make one copy-paste of all at the same time...