Most valuable professional
  • Hot Topics

Excel Find nth position of a character in a string using formula

Hello Guys, I am trying to work out how to get nth position of a character in a string. For example in this Code: kjishdfiuayigdscka if I use the formula Code: =FIND("i",I$1) , it will give me answer 3. But I want the position of 3rd "i" in the string. The answer should be 12. How can I change this formula to get the correct result? Thanks Asad

This question generated 22 answers. To proceed to the answers, click here.

This thread is current as of June 12, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel