Microsoft Office Forums - View Single Post - [Solved] Text in string

Thread: [Solved] Text in string

View Single Post

Old

11-21-2014, 10:11 PM

jolivanes

jolivanes is offline

jolivanes uses Windows XP

Windows XP jolivanes uses Office 2007

jolivanes uses Office 2007

Office 2007

Advanced Beginner

Join Date: Sep 2011

Posts: 91

jolivanes will become famous soon enough

Default

If it is always between the 3rd and 4th forward slashes, this does it also I think.
=TRIM(MID(A3,FIND(CHAR(1),SUBSTITUTE(A3,"/",CHAR(1),3))+1,FIND(CHAR(1),SUBSTITUTE(A3,"/",CHAR(1),4))-1-FIND(CHAR(1),SUBSTITUTE(A3,"/",CHAR(1),3))))

Reply With Quote