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!

For a value in A1, you could use:
=LEFT(RIGHT(A1,LEN(A1)-SEARCH("alias",A1)-6),SEARCH(" ",RIGHT(A1,LEN(A1)-SEARCH("alias",A1)-6)))

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks so much! Worked perfectly!

Perhaps a non formula approach and two steps needed ( but no extra column)
Ctrl+H
Replace what : *alias??
With : ( leave blank)
Click replace all
Ctrl+H
Replace what: )
With: (leave blank)
Click Replace All

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post