Getting hyperlinks

[horst]

Hi,
I have in a cell (Excel 2002) a text with a hyperlink.
How can I get in another cell this hyperlink (as simple text)?
Thanks
Horst

[George Gee]

Copy the hyperlink to your new cell,
right-click the copy > Hyperlink > Remove Hyperlink.

The cell should now display ordinary text.

George Gee


horst wrote:
> Hi,
> I have in a cell (Excel 2002) a text with a hyperlink.
> How can I get in another cell this hyperlink (as simple text)?
> Thanks
> Horst

[horst]

Thank you, but I want to get the hyperlink and not the text!
Horst

On 27.09.2005 20:31, George Gee wrote:

> Copy the hyperlink to your new cell,
> right-click the copy > Hyperlink > Remove Hyperlink.
>
> The cell should now display ordinary text.
>
> George Gee
>
>
> horst wrote:
>
>>Hi,
>>I have in a cell (Excel 2002) a text with a hyperlink.
>>How can I get in another cell this hyperlink (as simple text)?
>>Thanks
>>Horst
>
>
>

[George Gee]

I'm sorry horst, but I really cannot understand what it is you require!

What does this hyperlink point to?
A website, an email address, a place in an Excel workbook?

Please try to give us some information, so that we may try to
help you!

In the meantime, try this:
Type the text you require, in the cell you require.
Right-click the cell, point to Hyperlink, and click and see if there is
anything there that may be what you are looking for.
Especially "Text to display", at the top.

Or:
Right-click your existing hyperlink, point to Hyperlink, and click,
Have a look at "Text to display", at the top.


George Gee


horst wrote:
> Thank you, but I want to get the hyperlink and not the text!
> Horst
>
> On 27.09.2005 20:31, George Gee wrote:
>
>> Copy the hyperlink to your new cell,
>> right-click the copy > Hyperlink > Remove Hyperlink.
>>
>> The cell should now display ordinary text.
>>
>> George Gee
>>
>>
>> horst wrote:
>>
>>> Hi,
>>> I have in a cell (Excel 2002) a text with a hyperlink.
>>> How can I get in another cell this hyperlink (as simple text)?
>>> Thanks
>>> Horst

[Anne Troy]

Try this, Horst:
http://vbaexpress.com/kb/getarticle.php?kb_id=227
************
Anne Troy
www.OfficeArticles.com

"horst" <[email protected]> wrote in message
news:[email protected]...
> Thank you, but I want to get the hyperlink and not the text!
> Horst
>
> On 27.09.2005 20:31, George Gee wrote:
>
>> Copy the hyperlink to your new cell,
>> right-click the copy > Hyperlink > Remove Hyperlink.
>>
>> The cell should now display ordinary text.
>>
>> George Gee
>>
>>
>> horst wrote:
>>
>>>Hi,
>>>I have in a cell (Excel 2002) a text with a hyperlink.
>>>How can I get in another cell this hyperlink (as simple text)?
>>>Thanks
>>>Horst
>>
>>

[horst]

Thank you Anne, this is exactly what I was looking for!
Horst

On 27.09.2005 22:00, Anne Troy wrote:

> Try this, Horst:
> http://vbaexpress.com/kb/getarticle.php?kb_id=227
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "horst" <[email protected]> wrote in message
> news:[email protected]...
>
>>Thank you, but I want to get the hyperlink and not the text!
>>Horst
>>
>>On 27.09.2005 20:31, George Gee wrote:
>>
>>
>>>Copy the hyperlink to your new cell,
>>>right-click the copy > Hyperlink > Remove Hyperlink.
>>>
>>>The cell should now display ordinary text.
>>>
>>>George Gee
>>>
>>>
>>>horst wrote:
>>>
>>>
>>>>Hi,
>>>>I have in a cell (Excel 2002) a text with a hyperlink.
>>>>How can I get in another cell this hyperlink (as simple text)?
>>>>Thanks
>>>>Horst
>>>
>>>
>

[Gord Dibben]

Horst

If you just have a few of these you could do it manually.

Activate the Web Toolbar from View>Toolbars.

Click on the hyperlink in the cell to follow it.

Copy the address/path from the Web address dialog.

Paste it into Excel.


Gord Dibben Excel MVP

On Tue, 27 Sep 2005 21:33:28 +0200, horst <[email protected]> wrote:

>Thank you, but I want to get the hyperlink and not the text!
>Horst
>
>On 27.09.2005 20:31, George Gee wrote:
>
>> Copy the hyperlink to your new cell,
>> right-click the copy > Hyperlink > Remove Hyperlink.
>>
>> The cell should now display ordinary text.
>>
>> George Gee
>>
>>
>> horst wrote:
>>
>>>Hi,
>>>I have in a cell (Excel 2002) a text with a hyperlink.
>>>How can I get in another cell this hyperlink (as simple text)?
>>>Thanks
>>>Horst
>>
>>
>>

[Anne Troy]

Cool beans.
************
Anne Troy
www.OfficeArticles.com

"horst" <[email protected]> wrote in message
news:[email protected]...
> Thank you Anne, this is exactly what I was looking for!
> Horst
>
> On 27.09.2005 22:00, Anne Troy wrote:
>
>> Try this, Horst:
>> http://vbaexpress.com/kb/getarticle.php?kb_id=227
>> ************
>> Anne Troy
>> www.OfficeArticles.com
>>
>> "horst" <[email protected]> wrote in message
>> news:[email protected]...
>>
>>>Thank you, but I want to get the hyperlink and not the text!
>>>Horst
>>>
>>>On 27.09.2005 20:31, George Gee wrote:
>>>
>>>
>>>>Copy the hyperlink to your new cell,
>>>>right-click the copy > Hyperlink > Remove Hyperlink.
>>>>
>>>>The cell should now display ordinary text.
>>>>
>>>>George Gee
>>>>
>>>>
>>>>horst wrote:
>>>>
>>>>
>>>>>Hi,
>>>>>I have in a cell (Excel 2002) a text with a hyperlink.
>>>>>How can I get in another cell this hyperlink (as simple text)?
>>>>>Thanks
>>>>>Horst
>>>>
>>>>
>>