extracting last name from full name
I have a calc field to extract the last name from a full name field in the format SMITH, JOHN.
The formula is LeftWords(fullname;1).
I need to be able to extract the last name when it has a space, e.g., VAN BEETHOVEN, LUDWIG. My current formula returns VAN. If I change the formual to (fullname; 2) I get VAN BEETHOVEN but also SMITH, JOHN for last name.
Is there a way to do this?