pull text inside a qoute

[ExcelNewbie2020]

Could an Excel formula be used to extract text from within a quotation mark? thank you in advance..

	result​
the "2" quick "brown" fox "jump" over the "4 lazy dog"​	2​	brown​	jump​	4 lazy dog​
"12 brown dog", with lazy "fox"​	12 brown dog​	fox​
"1000 horsemen" gather​	1000 horseman​

 

[Giordano Bruno]

You can use FIND e.g. =FIND("""",A1,8) The 8 refers to the starting position, so it would increase progressively as examples of the quotation marks are found. Best to use a few helper cells. Does that help?

 

[ExcelNewbie2020]

T

You can use FIND e.g. =FIND("""",A1,8) The 8 refers to the starting position, so it would increase progressively as examples of the quotation marks are found. Best to use a few helper cells. Does that help?

thank you, i am looking that the result would look like these (will show the word or text inside the qoutation mark).

 

[Sanjeev1976]

Try :

=IFERROR(INDEX(TEXTSPLIT(A1,""""),,SEQUENCE(1,10,2,2)),"")

 

[Giordano Bruno]

To start you off, put the "2" quick "brown" fox "jump" over the "4 lazy dog" in cell A1
B1 =FIND("""",$A$1)+1
C1 =FIND("""",$A$1,B1+1)
D1 =C1-B1
E1 =FIND("""",$A$1,C1+1)+1
F1 =FIND("""",$A$1,E1+1)
G1 =F1-E1
H1 =MID(A1,B1,D1)
I1 =MID($A$1,E1,G1)