help to find a string for 4th occurance

's Computer Specifications

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.

's Computer Specifications

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
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Monthly Meeting fourth occurance last occurance duplication	Robert	Microsoft Outlook Calendar	2	1st Jan 2009 04:59 PM
find last occurance of a character in a string	=?Utf-8?B?WUdQ?=	Microsoft Access Queries	3	4th Mar 2005 02:09 AM
VBA - Find every occurance of string in workbook, write to 1st she	=?Utf-8?B?RG91Zw==?=	Microsoft Excel Programming	1	15th Nov 2004 04:19 AM
Re: Find Nth occurance of a substring in a string	Dan E	Microsoft Excel Worksheet Functions	2	16th Jul 2003 01:06 AM
Re: Find Nth occurance of a substring in a string	Alain CROS	Microsoft Excel Worksheet Functions	1	16th Jul 2003 12:18 AM