Is there any SIMPLE excel function that can find the (n)th matched of a string in a string?
I need to extract the number and text, separated by "+" as in example below:
In cell A2 I have value: "abcd+123+xyz".
This is what I'm doing:
In cell A3, I add two more "++" to the end of A1 cell value
Cell A4 I have formular:
=LEFT(B3,SEARCH("+",B3)-1)
and cell A5:
=MID(B3,LEN(B4)+2,SEARCH("+",B3,LEN(B4)+2)-LEN(B4)-2)
and cell A6:
=SUBSTITUTE(MID(B3,LEN(B4&B5)+3,20),"+","")
Is there anything like this:
findthis(string, string-to-find, 2nd-mached)
without writing VBA code?
I don't think there is such function, and I can find one more solution to my problem via this thread:
http://www.excelforum.com/excel-form...r-x-and-y.html
Bookmarks