Hi guys, I'm looking for a formula that will remove the text between the first and last space in a cell e.g. 'Mr Brian M Taylor' becomes 'Mr Taylor' in the cell next to it.

Ideally I'd like it to work when there's only 1 space as well e.g. 'Mr Taylor' displays as 'Mr Taylor' in the next cell using the same forumla as the first example.


This is a bit advanced for me (but learning all the time :D) so any help would be fantastic.
Cheers, James.