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?