Extract text string using MID

T

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
 
T

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
 
B

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
 
T

Turk

Dear Biff,

This works, thank you~

Turk


Biff said:
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
Click to expand...
 
Top