Is there a Formula out there??

[PALLUAN]

Hello everybody,
I'm new to this forum and I come up with a difficult (for me) problem to solve.
I've got a cell with a list of names comma separated
(Mr. Michael Quinn, Mr. Matthew Fresen, Mrs. Paula Plico)

I need different formulas that gives me the different names as results:
Cell 1 Michael Quinn
Cell 2 Matthew Fresen
Cell 3 Mrs Paupa Plico

Is there a way to do it?

Thank you

Antonio Palluan

 

[PALLUAN]

Sorry the Cell 3 has to be Paula Plico (not Mrs Paupa Plico)... Sorry...