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))))

 

[Simon Lloyd]

Hi

I have many cell with values lik
01/ab123/0
01/123A/0
1/1A/
I want to extract the middle value of each cell how could I do This.Use this formula in the cells next to your data and copy down

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

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com

 

[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))