Help with Address Formula
Try this:
=LEFT(A1,FIND("^",SUBSTITUTE(A1," ","^",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))
"Steve M" wrote:
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
|