Want to return all but the last word

[Steve M]

I am looking for a formula that will return all words except for the last
word.
Eample:. in cell A1 I have: Castleton Parkway Blvd--I want to return in
cell A2: Castleton Parkway

TIA

 

[Bondi]

Steve M skrev:

I am looking for a formula that will return all words except for the last
word.
Eample:. in cell A1 I have: Castleton Parkway Blvd--I want to return in
cell A2: Castleton Parkway

TIA

Hi Steve,

There is properly an easier way b ut this seem to work:

=LEFT(A1,LEN(A1)-LEN(RIGHT(A1,LEN(A1)-FIND("^^",SUBSTITUTE(A1,"
","^^",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))))

Regards,
Bondi

 

[Steve M]

I am sorry-I tried but cannot get this to work. I have tried it as a
function and as an array function. I get the same result-- #VALUE!

 

[Max]

Steve,

For your easy ref,
here's a working implementation of Bondi's suggestion (it works!):
http://cjoint.com/?melcNLLTYT
Return All but Last Word.xls