# help to find a string for 4th occurance

=?Utf-8?B?RWRkeSBTdGFu?=
Guest
Posts: n/a

 22nd Sep 2007

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)

Peo Sjoblom
Guest
Posts: n/a

 22nd Sep 2007
Try

=MID(E7,FIND("^^",SUBSTITUTE(E7,C7,"^^",4))+7,17)

--

Regards,

Peo Sjoblom

"Eddy Stan" <(E-Mail Removed)> wrote in message
news:5C463907-34E2-4947-9477-(E-Mail Removed)...
>
> 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.
>

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Robert Microsoft Outlook Calendar 2 1st Jan 2009 04:59 PM =?Utf-8?B?WUdQ?= Microsoft Access Queries 3 4th Mar 2005 02:09 AM =?Utf-8?B?RG91Zw==?= Microsoft Excel Programming 1 15th Nov 2004 04:19 AM Dan E Microsoft Excel Worksheet Functions 2 16th Jul 2003 01:06 AM Alain CROS Microsoft Excel Worksheet Functions 1 16th Jul 2003 12:18 AM

Features