Select the data Column, A say, and choose Data Text to Columns with
the options:

Step 1. Delimited
Step 2. Other delimiter and type "
Step 3. Choose do not import for first and third columns, and
destination as $B$1


Tubthumper wrote:

I have a long list of URLs, and I'd like to extract just the information
between the "speech marks". Any suggestions?

<option value="ohwell.info"ohwell.info
<option value="thewebtunnel.com"thewebtunnel.com
<option value="shipproxy.com"shipproxy.com
<option value="filtercloak.com"filtercloak.com
<option value="brownman.info"brownman.info

Many thanks