substring operations

  • Thread starter Thread starter jana
  • Start date Start date
J

jana

hi ,
is there a way to find the n'th instance of a substring in its
parent string ?

regards,
jana
 
Hi!

Do you mean that you want to know the starting position of the nth instance
of the substring?

=FIND("~",SUBSTITUTE(A1,"substring","~",instance_number))

In the formula the tilde character is used as a "marker".

If your string contains "~" tilde characters then use some other "unique"
character that IS NOT in your string.

Biff
 
You must log in or register to reply here.

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

substring operation 1
search text for substring and change text colour of substring 5
Text string searches 3
text search within an array 3
check substring of a string in Excel VBA 2
Search and replace string within fields across table 4
Help with Regexp, please 12
Sum.product with text conditionals 4

Back
Top