Hi,

I have a list of names in column A of my spreadsheet, they take the form of, for example: JOHNSTONE MARK MR
Where JOHNSTONE is the surname
MARK is the forename
and MR is his title.

The problem is of course that the surname, forename can be of any length so I cant use a simple RIGHT or LEFT function and I am stumped how to do it.
Is there a function that will allow me to extract into columns B, C & D the
surname, forename and title for each name in my list ?

Many thanks for your help.