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: 325 Castleton Parkway Blvd--I want to
return in cell A2: 325 Castleton Parkway

Bondi supplied this formula :
=LEFT(A1,LEN(A1)-LEN(RIGHT(A1,LEN(A1)-FIND("^^",SUBSTITUTE(A1,"
","^^",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))))

but I cannot get it to work--I get a #VALUE! result whether or not I use it
as an array.


TIA