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