remove only the last word from each lin

J

jajoseph

I have been looking in the archives and I have not been able to find an
excel formula to do the following. I need a formula to remove only the
last word from each line automatically.

4076 St. Andrews Ct. Canfield
7369 Spring Lake Boardman
108 S. Lakeview Youngstown
4028 Burgett Lane Poland
21 Meadow Court Austintown
 
J

JE McGimpsey

One way:

=TRIM(LEFT(A1,FIND("$",SUBSTITUTE(A1,"_","$",LEN(A1) -
LEN(SUBSTITUTE(A1,"_",""))))))

where "_" represents a space character to prevent unfortunate line wrap.
 
Top