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