I have a name field supplied by a school in this format:
(last name comma firstname)
I need a LastName field and a FirstName field from the data.
I have used LeftWords and RightWords, but it does not handle the hyphenated names and I have plenty of both first and last names that are hypenated. Can I extract the text to the left and right of the comma?