Which formula do I use to separate the string

Smith,Bob J

into three separate last name, first name, and middle name columns? There
are 1000 rows and all names will be of variable length.

Last First Middle
Smith Bob J

Thanks,
Melanie