Answers for "excel search for second instance of character"

Whatever

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

Source

Code answers related to "excel search for second instance of character"

Code answers related to "Whatever"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#