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