extracting text from within quotes

[Sheepkin_Coat]

i have a list of things that are on some CD's and i want to put them on a Excel spreadsheet, but i do not want the numbers after the first set of speech marks, i have tried MID but as you can see not all of the items are the same length

4U 070;"N.o.B.I. Brainstorm";"53B900AD";"B4DA24CE"
4U 071;"N.o.B.I. Racing";"B33D109D";"86DBAFFE"
4U 072;"CCD-Demo";"C022F97A";"E9A54209"
4U 073;"Inshape";"A5635374";"2E3245D9"
4U 073;"Books";"A5635374";"2E3245D9"
4U 073;"Hardware";"A5635374";"2E3245D9"
4U 073;"Raystart";"A5635374";"2E3245D9"
4U 074;"Argon";"47558C80";"9AE70A2E"
4U 074;"Crypton";"47558C80";"9AE70A2E"

i want the first speech marks not the second or third

[:) Sixthsense :)]

What do you mean by speech marks? can you please show the expected result?

[Sheepkin_Coat]

i have a list of things that are on some CD's and i want to put them on a Excel spreadsheet, but i do not want the numbers after the first set of speech marks, i have tried MID but as you can see not all of the items are the same length

4U 070;"N.o.B.I. Brainstorm";"53B900AD";"B4DA24CE"
4U 071;"N.o.B.I. Racing";"B33D109D";"86DBAFFE"
4U 072;"CCD-Demo";"C022F97A";"E9A54209"
4U 073;"Inshape";"A5635374";"2E3245D9"
4U 073;"Books";"A5635374";"2E3245D9"
4U 073;"Hardware";"A5635374";"2E3245D9"
4U 073;"Raystart";"A5635374";"2E3245D9"
4U 074;"Argon";"47558C80";"9AE70A2E"
4U 074;"Crypton";"47558C80";"9AE70A2E"

i want the first speech marks not the second or third

this is in column B
4U 070;"N.o.B.I. Brainstorm";"53B900AD";"B4DA24CE"

column A
i have used =left(A2,6), which gets me 4U 070

what i want in column C is
N.o.B.l. Brainstorm

what i mean about speech codes is "

[dilipandey]

Hi Sheepkin_coat,

Assuming your data is in column A, use below formula in B1 and drag it down:-

=MID(A1,SEARCH(";",A1)+2,(SEARCH(";",A1,SEARCH(";",A1)+1)-2-SEARCH(";",A1)-2)+1)

Regards,
DILIPandey
<click on below * if this helps>

[Sheepkin_Coat]

Hi Sheepkin_coat,

Assuming your data is in column A, use below formula in B1 and drag it down:-

=MID(A1,SEARCH(";",A1)+2,(SEARCH(";",A1,SEARCH(";",A1)+1)-2-SEARCH(";",A1)-2)+1)

Regards,
DILIPandey
<click on below * if this helps>

Thanks for that it's great and i have give you some REP

[dilipandey]

you are welcome Sheepkin_Coat... cheers

Suggest you to mark this thread as [SOLVED].. thanks.


Regards,
DILIPandey
<click on below * if this helps>