Answers for "excel formula find 2nd occurrence in string"

5

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))
Posted by: Guest on September-04-2020
0

excel find position of second to last character in a string

=FIND(CHAR(160),SUBSTITUTE(text,"@",CHAR(160),N))
Posted by: Guest on September-03-2020

Code answers related to "excel formula find 2nd occurrence in string"

Browse Popular Code Answers by Language