Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
I need to find a string "pv" occurring 3rd time in a cell and pick 3 subsequent words from the cell example : the following sentense is there in c5 cell 111111 pv 222222 pv 3333333 44444 55555 pv 66666 pv 7777 pv 8888 the result : I need a function in cell D5 to return it must be like : find(pv, c5, 3rd occurancce, next 3 words) and give result 66666 pv 7777 pv 8888 i know we cannot use find() but i need a function something like that and NOT a macro please. Eddy Stan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
help to find a string for 4th occurance | Excel Worksheet Functions | |||
Find next occurance | Excel Discussion (Misc queries) | |||
frequency of occurance of all words in 2-D array | Excel Discussion (Misc queries) | |||
Find last occurance of character in text string | Excel Worksheet Functions | |||
Occurance Number Within a String | Excel Discussion (Misc queries) |