hi , is there a way to find the n'th instance of a substring in its parent string ? regards, jana
J jana Oct 26, 2005 #1 hi , is there a way to find the n'th instance of a substring in its parent string ? regards, jana
B Biff Oct 26, 2005 #2 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
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
