Question : excel formula find 2nd occurrence in string
Answered by : daniel-ferry
To find the 2nd backslash in the text in cell A1:
=SEARCH("^", SUBSTITUTE(A1, "\","^",2))
To find the 4th period in the text in cell A1:
=SEARCH("^", SUBSTITUTE(A1, ".","^",4))
Source : http://academy.excelhero.com/ | Last Update : Fri, 11 Sep 20
Question : excel find position of second to last character in a string
Answered by : brian-w
=FIND(CHAR(160),SUBSTITUTE(text,"@",CHAR(160),N))
Source : https://exceljet.net/formula/find-nth-occurrence-of-character | Last Update : Thu, 10 Sep 20