How can I fix HYPERLINK(B2,E2) to the resulting text and link?
 

I'm using excel 2003. I have created a column of text descriptions, each of
which is linked to a web page for the product it describes. I have done this
by merging a column with the hyperlinks in it with a column of descriptions,
eg: =HYPERLINK(B2,E2). The hyperlinks in the hyperlink column are in turn
created by combining a cell value with a text string.

I now want to keep the column of hyperlinked descriptions, but get rid of
all the other columns, so I need to fix the values of the hyperlinks and text
to the values that result from the formulas I've used. The only problem is
that pasting just the values gives only the text, without its hyperlink.

Can anyone help? Many thanks, Lisa

How can I fix HYPERLINK(B2,E2) to the resulting text and link?
 

I think the easiest way out of this is to just hide those columns--not delete
them.




Lisa wrote:

I'm using excel 2003. I have created a column of text descriptions, each of
which is linked to a web page for the product it describes. I have done this
by merging a column with the hyperlinks in it with a column of descriptions,
eg: =HYPERLINK(B2,E2). The hyperlinks in the hyperlink column are in turn
created by combining a cell value with a text string.

I now want to keep the column of hyperlinked descriptions, but get rid of
all the other columns, so I need to fix the values of the hyperlinks and text
to the values that result from the formulas I've used. The only problem is
that pasting just the values gives only the text, without its hyperlink.

Can anyone help? Many thanks, Lisa

--

Dave Peterson

How can I fix HYPERLINK(B2,E2) to the resulting text and link?
 

Thanks Dave

I actually wanted to paste just these descriptions with their links into an
HTML page - I've now discovered that this works as it is - just copying that
column pastes the values I want into the HTML page. As you say though, will
just hide the columns for the purposes of the excel document, cheers.

How can I fix HYPERLINK(B2,E2) to the resulting text and link?
 

This seems to work:
Copy the cells with the descriptions (E2 in your example).
Click on the cell with the hyperlink (B2 in your example) - remember to hold
down mouse button until cursor becomes a cross otherwise you will activate
the hyperlink.
Now click Edit, Paste Special..., choose Values, and Click OK.
If you know what's good for you, you WILL try this on a COPY of your
spreadsheet, won't you?

"Lisa" wrote:

I'm using excel 2003. I have created a column of text descriptions, each of
which is linked to a web page for the product it describes. I have done this
by merging a column with the hyperlinks in it with a column of descriptions,
eg: =HYPERLINK(B2,E2). The hyperlinks in the hyperlink column are in turn
created by combining a cell value with a text string.

I now want to keep the column of hyperlinked descriptions, but get rid of
all the other columns, so I need to fix the values of the hyperlinks and text
to the values that result from the formulas I've used. The only problem is
that pasting just the values gives only the text, without its hyperlink.

Can anyone help? Many thanks, Lisa