Thread: Return position of 2nd, 3rd, ect occurrence of a character in a st
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld
 
Posts: n/a
Default Return position of 2nd, 3rd, ect occurrence of a character in a st
On Tue, 14 Feb 2006 11:12:26 -0800, "jheby"
wrote:

the Excel =FIND command returns the position of the first instance of a
string that it finds. Is there any way to find position of the 2nd, 3rd, or
nth occurrence? Using =MID is too messy.

Download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr


Then use the formula:

=REGEX.FIND(StringToSearch, StringToFind, n)

where 'n' is the instance number of the string.

For a case-INsensitive version:

=REGEX.FIND(StringToSearch, StringToFind, n, FALSE)


--ron
Reply With QuoteReply With Quote