It seems, unfortunately, prefixes can only be recognized if they are separated from the rest of the title by a space. So, yes, you would have to move it to the end. But if you have set that as your preference for title formatting, it would be easier just to add the space.
I'm sure you've already figured this out, but just to be clear... The title formatting feature is not a method of specifying what prefixes are to be ignored for sorting purposes (but otherwise remain in the title). That's what some might expect, having seen the behaviour in other applications. This feature actually changes the title to the form specified. Records are always sorted according to the title—as it is recorded.
After struggling with this for a time, I got fed up and embraced the option of removing all prefixes. For the most part, that works well and avoids the issue. But the result still bothers me for many one-word (with the prefix removed) titles.
"Haine" (or Hate) and
"Boot" (or Boat) are just not the same as their proper titles. And these examples raise another tricky problem. Even as a unilingual anglophone, I know these titles as "La Haine" and "Das Boot." So "Hate" and "Boat" seem twice removed from what my brain wants to call them.