Maybe this

=MID(MID(MID(SUBSTITUTE(A1,"_","^",A2),1,256),FIND ("^",SUBSTITUTE(A1,"_","^",A2)),256),2,FIND("_",MI D(MID(SUBSTITUTE(A1,"_","^",A2),1,256),FIND("^",SU BSTITUTE(A1,"_","^",A2)),256))-2)

A1 is your string and A2 tells it where to start extraction from, in this
case the send "_" so A2 is 2
Mike

" wrote:

hi,

i have the following text:

AAA_llac_MAR_99_eg

i am trying to write a formula to extract the text between the second
and third occurance of '_" (the delimiter). Basically i want to
extract MAR. I am trying to do this using the MID and FIND statement.

Any help would be appreciated!

db