| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
