Recent content by elliotthope

All great responses everybody. I went with this as requested by Brian in the end: xinstance2 = InStr(xinstance1 + 1, iUPC, "/") xinstance3 = InStr(xinstance2 + 1, iUPC, "/") xinstance4 = InStr(xinstance3 + 1, iUPC, "/") So simple, yet i couldn't think of it yesterday! Thankyou all. Elliott

I use the following code to get the first and second instances of a "/" character. I cannot get my head around how to get the position of the third instance. Does anybody have any ideas?? Thanks, Elliott iUPC = "123-7754LF-(A/S red Top)-T19/97876564" 'get number of instances xTimes = 0...