I work for a law office, and we're provided with the full case caption in a cell, but I need to extract the data for mailing purposes. I've already figured out the functions for pulling addresses, but for some reason, I'm having a heck of a time getting the formula right to extract the first and last names of individuals from the following types of cell data (all names have been changed):

WELLS FARGO BANK, N.A. vs. SMITH, MAUREEN
THE BANK OF NEW YORK MELLON vs. JONES, GEORGIA
WELLS FARGO BANK, N.A. vs. ADAMS, AINSLEY
BAYVIEW LOAN SERVICING, LLC vs. WILSON, LUIS H.
CITIBANK, N.A. vs. SULLIVAN, MATTHEW
NATIONSTAR MORTGAGE, LLC vs. WILLIAMS, RONALD W.

Each of the above captions are currently in their own individual cell on my sheet.


Thanks!