help to find a string for 4th occurance

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"T" function broken? 11
Dynamic unlock a cell (under condition) 5
VBA Custom function for lookup 9
How to replace a formula string with * in the leading position? 3
help with code for conditional summary sheet 4
Excel functions - making flexible "range" in COUNTIF 4
Conditional Testing of an array 1
find a string of nth occurance & pick next 3 words 7

Top