Obtain Middle vlaue of text with unknow length

[Abdul Shakeel]

Hi,

I have many cell with values like
01/ab123/09
01/123A/09
1/1A/9
I want to extract the middle value of each cell how could I do This.

 

[Gary''s Student]

=LEFT(RIGHT(A1,LEN(A1)-FIND("/",A1,1)),-1+FIND("/",RIGHT(A1,LEN(A1)-FIND("/",A1,1))))

 

[T. Valko]

Try this:

=MID(A1,FIND("/",A1)+1,FIND("/",A1,FIND("/",A1)+1)-1-FIND("/",A1))

 

[Teethless mama]

=TRIM(MID(SUBSTITUTE(A1,"/",REPT(" ",99)),99,99))