View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eddy Stan Eddy Stan is offline
external usenet poster
 
Posts: 151
Default help to find a string for 4th occurance


I need excel function at b7 to find a string of 7 chrs (at c7) for its 4th
occurance in E7 (text 300+ chrs) and pick next 17 alpha numeric digits (from
E7).

something like...at b7
=mid(e7, find(c7,E7,4th occurance), 17)

my advance thanks to you.