Obtain Middle vlaue of text with unknow length

A

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.
 
G

Gary''s Student

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

Simon Lloyd

Abdul said:
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
Click to expand...

*=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
 
Top