0
Q:

excel formula find 2nd occurrence in string

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))

5
=FIND(CHAR(160),SUBSTITUTE(text,"@",CHAR(160),N))
0

New to Communities?

Join the community