Showing all data in a cell except the last word

brjv42

New Member
Joined
Nov 7, 2005
Messages
11
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
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,988
Code:
=LEFT(A1,SEARCH("@",SUBSTITUTE(A1," ","@",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))-1)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,686
Members
412,481
Latest member
nhantam
Top