Find the text

[NAVEEN C N]

I want to find out the text after comma (,).

23-1-175,0,15,12,0,303
i need a function which will find out "0" after the first comma (,) the text mentioned above.

Excel sheet attached with various possible number..

thanks in advance for your help..

 

[Hui]

B2: =MID(A2,FIND(",",A2)+1,FIND(",",RIGHT(A2,LEN(A2)-FIND(",",A2)))-1)

Copy down

 

[Sinu]

I want to find out the text after comma (,).

23-1-175,0,15,12,0,303
i need a function which will find out "0" after the first comma (,) the text mentioned above.

Excel sheet attached with various possible number..

thanks in advance for your help..

simple solution:
=FIND(0,<<Cell>>,FIND(",",<<Cell>>,1))

 

[NAVEEN C N]

Hi Hui..

Thanks for the reply.. its working fine..