Find n-th occurrence of a character

  • Thread starter Thread starter X-Ray
  • Start date Start date
X

X-Ray

How can I find (posistion of) the n-th (for example the second or third)
ocurrence of a specific character? The first or the last occurence is no
problem.
 
For the 3rd occurrence of n:

=FIND("^",SUBSTITUTE(A1,"n","^",3))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| How can I find (posistion of) the n-th (for example the second or third)
| ocurrence of a specific character? The first or the last occurence is no
| problem.
|
|
 
Back
Top