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))
=FIND(CHAR(160),SUBSTITUTE(text,"@",CHAR(160),N))