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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find the n-th occurance of a sustring within a string 13
finding n-th most frequently occuring word 4
Find xth occurrence of a specifiecd character in a string 3
How do I find the highest of the most repeating values in a list ofnumbers ie. the max of the modes 1
VBA code to pick up nth to (n+x)th character 0
Referencing cells dynamically 3
Help finding the last space in a cell 2
Scrabble Value calculation for Welsh words 0

Back
Top