AnsweredAssumed Answered

extracting last name from full name

Question asked by denno on Aug 6, 2011
Latest reply on Aug 6, 2011 by LaRetta_1

Title

extracting last name from full name

Post

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?

Thanks-

Outcomes