Hey Yahya
Thanks a lot. It works. Really saved me a lot of time and effort.
Wonderful
Thanks once again.
Ashish
On 6/15/09, Yahya wrote:
> FYI
>
>
> -- Forwarded message --
> From: Yahya
> Date: Sat, Jun 13, 2009 at 9:58 PM
> Subject: Re: $$Excel-
Dear Ashish
You can do it without a macro by using the Paste Special features of Excel.
Follow these steps:
1. In a blank cell, enter the number 1.
2. Select the cell and press *Ctrl+C*. The cell content (1) is now copied
to the Clipboard.
3. Hold down the *Ctrl* key as you click each
Dear Yahya
Thanks for your help and apologize for not posting all details in my
query earlier. The excel version I am using is Excel 2000.
Thanks again.
Ashish
On 6/13/09, Yahya wrote:
>
>
> Dear Ashish
>
>
> Which version of Excel you are using?
>
>
>
> Yahya
>
> On Fri, Jun 12, 2009 at 12
Dear Ashish
Which version of Excel you are using?
Yahya
On Fri, Jun 12, 2009 at 12:44 PM, Ashish Pradhan wrote:
>
> Hi
>
> I have downloaded some tables in excel using Copy/Paste Function (Not
> the "Get External Data" feature). Unfortunately, there are a lot of
> links in the excel cells.
>
