Formula

  • Thread starter dazoloko via OfficeKB.com
  • Start date
D

dazoloko via OfficeKB.com

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
 
M

Mike H

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
 
Top