Extract text between double quotes in variable length strings

[3gswish]

Hi everyone,

A bit of a challenge with this one... The last couple of hours searching have not resulted in a working solution, so I turn to you.

I have 253 cells in column AO that contain text, containing 1 to 6 chunks of text within "double quotes". Here is an example.

This is text that is "pretty"
This "text" is not "well formed" or well mannered
This "set of words" has been "significantly modified" and is "junk", "junk2" and "junk3"

The length of the text, the length of the quoted chunks, the number of quoted chunks, as well as the location of the quoted chunks within the string are completely variable.

The result I would like to acheive is for each chunk, without it's quotes, to be in the next columns on the same row.

The text is in row AO2:AO254, so chunks should end up in the same row, starting at column AP and higher.

The results would look like

[TABLE="width: 500"]
<tbody>[TR]
[TD]AP[/TD]
[TD]AQ[/TD]
[TD]AR[/TD]
[TD]AS[/TD]
[TD]AT[/TD]
[/TR]
[TR]
[TD]pretty[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]text[/TD]
[TD]well formed[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]set of words[/TD]
[TD]significantly modified[/TD]
[TD]junk[/TD]
[TD]junk2[/TD]
[TD]junk3[/TD]
[/TR]
</tbody>[/TABLE]



Any and all input would be very greatly appreciated - Thank you, Thank you, Thank you!

 

[TiAc85]

I've a short question about your code. How is it possible to split two different columns. In your script we are going to split column "AO". Is it possible to split column "B" in the same script?