Showing all data in a cell except the last word

[brjv42]

Hello,

I have a small problem that I need to get fixed. I am working on a mailing list and the name field is all in one cell. The names range from "John M. Smith" to "Cheryl Johnson" to "M/M Bob Herman". The question that I am asking is there a way to show everything in the cell EXCEPT the last word in that cell, like "John M." and "Cheryl" and "M/M Bob".

Thanks for all that help.

brjv42

 

[Oaktree]

=LEFT(A1,SEARCH("@",SUBSTITUTE(A1," ","@",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))-1)

 

[brjv42]

Thanks a million!!