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

kjishdfiuayigdscka
if I use the formula
=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