Re: Removing Text

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

One way:

Select the range to fix
edit|Replace
what: *=" (asterisk, equal sign, doublequote)
with: (leave blank)
replace all

then with that range still selected
edit|Replace
what: "* (doublequote, asterisk)
with: (leave blank)
replace all

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

--

Dave Peterson
.

Relevant Pages

  • Re: Extract the text between last comma and last but one comma.
    ... Select the range to fix ... what: *Seq (asterisk, Seq) ... Dave Peterson ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Macro Help
    ... select the range to fix ... (* (open paren, followed by an asterisk) ... I'm looking for a macro that will take a column of data that look like ... Dave Peterson ...
    (microsoft.public.excel.programming)