Hi All,

I am new to this thread and had a question regarding extracting a specific word from strings of various lengths. I am trying to find an excel formula that will extract the word that comes directly after "alias" in the following strings:

OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )

Shape ( type: esriFieldTypeGeometry , alias: Shape )

TAXID ( type: esriFieldTypeString , alias: TAXID , length: 13 )

Here is the formula I have come up with :

=LEFT(MID(A2,FIND(",",A2)+9,12),13)

Results : OBJECTID )
Shape )
TAXID, leng

I am trying to figure out a way to get rid of the parentheses (and any other text that may follow) following the word that comes after "alias"

Any help is appreciated! Thank you in advance!