ExcelBanter - Copy and paste

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Copy and paste (https://www.excelbanter.com/excel-discussion-misc-queries/32458-copy-paste.html)

Lionround

Copy and paste

I have a spreadsheet with hyperlinks. I want to change the text in the cell
by copying and pasting the text from another cell WITHOUT changing the
underlying hyperlink.

Dave Peterson

I copied, then paste special|Values and the old link was kept.

(I tested in xl2003)

Lionround wrote:

I have a spreadsheet with hyperlinks. I want to change the text in the cell
by copying and pasting the text from another cell WITHOUT changing the
underlying hyperlink.

--

Dave Peterson

All times are GMT +1. The time now is 10:32 PM.