Formula
 

Dear All

I have a cell which contains quite a long reference number. The Number is
divided up into 5 sections, a " / " being the separator.

How do I extract what is between the 2nd "/" and the 3rd "/" ?

Heres hoping you can help.

Cheers

Darren

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200811/1

Formula
 

Try this

=MID(A1,FIND(CHAR(7),SUBSTITUTE(A1,"/",CHAR(7),2))+1,FIND(CHAR(7),SUBSTITUTE(A1,"/",CHAR(7),3))-FIND(CHAR(7),SUBSTITUTE(A1,"/",CHAR(7),2))-1)

Mike

"dazoloko via OfficeKB.com" wrote:

Dear All

I have a cell which contains quite a long reference number. The Number is
divided up into 5 sections, a " / " being the separator.

How do I extract what is between the 2nd "/" and the 3rd "/" ?

Heres hoping you can help.

Cheers

Darren

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200811/1

Formula
 

Thanks Mike

Works a Treat

Mike H wrote:
Try this

=MID(A1,FIND(CHAR(7),SUBSTITUTE(A1,"/",CHAR(7),2))+1,FIND(CHAR(7),SUBSTITUTE(A1,"/",CHAR(7),3))-FIND(CHAR(7),SUBSTITUTE(A1,"/",CHAR(7),2))-1)

Mike

Dear All

[quoted text clipped - 8 lines]

Darren

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200811/1