Extracting specific text from cells

Hi
I am using Microsoft Excel 2007 and I am trying to extract the names from
example here: "Chuene, Dorcas, Mrs name.nameme@gmail.com"

I basically just want those full names on a separate cell. I've figured out how to extract the email address, but I just can't seem to extract the other text!

I've used =TRIM(RIGHT(SUBSTITUTE(LEFT(A56,FIND(" ",A56)-1)," ",REPT(" ",2)),99)) but it doesn't seem to work on all the cells, only some.

Any advice?

Ok, I used your formula but it gives me a value error. I changed the 160 to 100 and it worked. Yet the problem is that there are 200 more cells that I want to do the same with and their names differ in each one. So it wont be 100 all the time

Untitled.png

I didn't know how to attach the workbook so here's a screenshot of the formula. Hope it's good enoug. I am quite new to excel and most of the formulas I've gotten from the net.

Thanks