One way:

=SUBSTITUTE(SUBSTITUTE(MID(A1,FIND("""",A1)+1,255) ,"""",""),",","")

Biff

"Turk" wrote in message
...
Dear all,

I have got a text string as below

She is a girl,,,,,"I am a boy",""

What the formula should be to extract the string between ,,,,," and ",""
so that the result comes out with I am a boy ?

Thanks

Turk