Excising text from string in Cell from find(substring) to end - Microsoft Community

the actual situation isn't quite grandiose.  have dataset of names , among other things, addresses.  address field single string of form:

<street number><sp><sn1><sp><sn2><sp>...<snn><sp><"ste"><sp><identifier><","><sp><city><","><st>;

where "sn1" through "snn" "street name" comprised of variable number of words/characters;

i "normalized" data substitute "ste" "#", "bldg," etc. alternates exist;

and suite "identifier" can variable number/format of (text) letters, numerals and/or symbols.

[aside] it's easy enough, using trim() drop end of string starting "," separator between suite identifier , "city",

and easy enough drop " ste " string,

but because remaining "identifier" can have arbitrary length , content (as can arbitrary number of chars/words left of it) - if adopt approach, seem stuck recognizing "identifier" in meaningful or error-free way.

i "normalized" data in hope find function (hopefully without dipping in vb) like:

"find last instance of <substring> within cell; (in case, " ste " substring)

and delete chars <substring> end of cell string, inclusive."

but far, nothing i'm aware of or have been able discover can this.  ideas, suggestions or solutions?  on face of it, can't first person want/need street name proper, must have figured out, years ago.....

if understand correctly, want not including the”ste”?
if so, , assuming total address string in a1, work you?
=left(a1,find(“ste”,a1,1)-1)

Office / Excel / Other/unknown / Office 2016