| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help to find a string for 4th occurance
Try
=MID(E7,FIND("^^",SUBSTITUTE(E7,C7,"^^",4))+7,17) -- Regards, Peo Sjoblom "Eddy Stan" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to find last occurance | Excel Discussion (Misc queries) | |||
| Find next occurance | Excel Discussion (Misc queries) | |||
| Find last occurance of character in text string | Excel Worksheet Functions | |||
| Occurance Number Within a String | Excel Discussion (Misc queries) | |||
| Find last occurance of text in range | Excel Worksheet Functions | |||
Linear Mode
