How to remove the last word in a field?

[bradford]

Hi.

I have an old address book (.cwk) that clumped the first and last name together. I am hoping to create a new field that trims the last word off of text value in this field so I'm left with everything but the last name. I've tried a few calcs but I can't seem to get this working.

[comment]

Try:

LeftWords ( FullName ; WordCount ( FullName ) - 1 )

Note that some last names can be two or more words.