FG
💻 Software

Using Paste Special > Values with the HYPERLINK function in Excel

Fresh5 days ago
Mar 15, 202647814 views
Confidence Score0%
0%

Problem

I have a long list of data in Excel 2007. Using the Hyperlink function: I've added individual links to them all. Now I want to get rid of the function and just leave the data with the link. If I do Paste Special > Values, it does the job but the link will be removed. How can I paste the values and …

Error Output

=HYPERLINK(C2,A2)

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Using Paste Special > Values with the HYPERLINK function in Excel

Low Risk

How about a paste out to Word? (and then copy it there and paste back into Excel if you really need it back in Excel). This retains both the link and the title, and is clickable. No paste special required, although depending on your settings you may…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment