Extract text string using MID

[Turk]

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

 

[Biff]

One way:

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

Biff

 

[Turk]

Dear Biff,

Thanks for your prompt response.

However the formula doesn't work when there are some more characters follow
the strings

ie: She is a girl,,,,,"I am a boy",""she is a woman

returns I am a boyshe is a woman

but I only want the result to be I am a boy

Pls help


Turk

 

[Biff]

Try this:

=LEFT(MID(A1,FIND("""",A1)+1,255),FIND(",",MID(A1,FIND("""",A1)+1,255))-2)

I'm assuming every entry has as part of the string:

.........."some text",..............

If not then post SEVERAL representative samples so we can see what's needed.

Biff

 

[Turk]

Dear Biff,

This works, thank you~

Turk

Try this:

=LEFT(MID(A1,FIND("""",A1)+1,255),FIND(",",MID(A1,FIND("""",A1)+1,255))-2)

I'm assuming every entry has as part of the string:

........."some text",..............

If not then post SEVERAL representative samples so we can see what's
needed.

Biff

 

[Biff]

You're welcome. Thanks for the feedback!

Biff

Dear Biff,

This works, thank you~

Turk