- Thread starter excelent
- Start date

Hi ,

Why don't you also post the length of the formula you have developed ?

Narayan

Why don't you also post the length of the formula you have developed ?

Narayan

http://www.extendoffice.com/documents/excel/1052-excel-find-nth-occurrence.html

http://excel.tips.net/T003324_Finding_the_Nth_Occurrence_of_a_Character.html

Can't get shorter than 47 unless UDF is used

=MID(B3,FIND("~",SUBSTITUTE(B3,",","~",6))+1,4)

Yes the one you posted is almost excactly the same as mine

=MID(B3,FIND("#",SUBSTITUTE(B3,",","#",6))+1,4)

except for the #/~

well i didnt se that solusion before i wrote this one back in 2012

in a Dennish forum named eksperten.dk

so i guess we cant get it shorter than this,- well 47 is not that bad

thanks for your input.

Last edited:

Hi Waqar,

That's okay for the specific entry.

But suppose if the position of word "GOAL" is somewhere else?

e.g.

2009-01-15,35.80,36.50,34.30,35.30,13993900,0,GOAL,HEY,34

Hi @Haz, I think we can not use wildcard in "FIND", I've assumed you were referring "SEARCH"

Regards,