Removing the last word from a line of text
I am trying to separate a 'full name' field into just two fields 'last name' and 'first name(s)'.
I have successfully extracted the last name by using the RightWords text function and placed this into a new field.
Now I want to either remove the last name from the original field of extract all the text that came before the last name to place into another new field called 'first names'. I cannot use the LeftWords function as the number of words will vary from record to record.
I know there will be a simple solution but I only seem to find a way to trim letters not words.
Could anyone point me in the right direction please?