You can use this:
MiddleWords ( YourTextField ; WordNumberYouWant; 1)
- if the WordNumberYouWant is left empty it will return the first word. If you don't want that you could catch that with a Case Statement.
- the text 'Marks&Spencer' is two words, as also is 're-invent'
- if you specify a number more than the number of words in the text field it will return blank
Yep, that did the trick. Thanks!