Friday, 16 September 2016

Find the nth Occurrence of a Character in a cell

If you want to find

 

A1 = This World is Very Big

 

To find the place of 3rd I Use the following formula :  FIND("i",A1,FIND("i",A1)+3)

 

Here 3 represent nth occurrence

Posted by

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)