Share via

How can copy/paste formula cell as hyperlink in excel?

Anonymous
2023-12-11T14:27:04+00:00

I am trying to copy a formula cell that generates hyperlinks from cell content using some formula. Now when I try to "copy" and "paste value" that formula to another Excel file I am not getting the hyperlink, only plain text after I do Paste special > Paste Values. I tried all the options of Paste Special but none of them paste the values as hyperlinks. However, if I first copy/paste cell values to Word and then copy from Word and paste them into Excel I get the cell values as hyperlinks.

Example:

Content of Cell A1 = Try it » (https://www.w3schools.com/js/tryit.asp?filename=tryjs_regexp_i)

Content of Formula cell B1 = HYPERLINK(MID(A1,SEARCH("(",A1)+1,SEARCH(")",A1)-SEARCH("(",A1)-1),LEFT(A1, SEARCH(" (", A1) - 1))

Is there any way to copy the formula cell value as a hyperlink directly from one Excel to another or between two Excel sheets of the same Excel file as I can replicate the same issue using one Excel file using sheet1 and sheet2?

I have asked this question onStackOverflow also but have not gotten a resolution so far.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

9 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-12-12T22:17:45+00:00

    Thanks, Anna,

    In this solution, I have to repeat the steps for each copied cell and is not efficient.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-12-13T03:17:40+00:00

    record a macro for below?

    Copy the cell with the hyperlink formula. Go to the destination cell and press Ctrl+Alt+V to open the Paste Special dialog box. Select the Values option and click OK. Right-click on the destination cell and select Hyperlink. In the Insert Hyperlink dialog box, select the Existing File or Web Page option. Paste the address of the hyperlink in the Address box and click OK.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2023-12-12T08:10:28+00:00

    In that case, you can try the following steps:

    Copy the cell with the hyperlink formula. Go to the destination cell and press Ctrl+Alt+V to open the Paste Special dialog box. Select the Values option and click OK. Right-click on the destination cell and select Hyperlink. In the Insert Hyperlink dialog box, select the Existing File or Web Page option. Paste the address of the hyperlink in the Address box and click OK.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2023-12-11T18:53:51+00:00

    Hi Anna,

    Thanks for taking the time to reply to my question, I want to copy the cell as a hyperlink only without any reference to the source cell. i.e. the same functionality that I get after copying the cell to a Word document and then copying it back to an Excel sheet.

    Regards,

    Hemendr

    Was this answer helpful?

    0 comments
  5. Anonymous
    2023-12-11T18:24:28+00:00

    Hi Hemendr

    I'm AnnaThomas and I'd happily help you with your question. In this Forum, we are Microsoft consumers just like yourself no one here is a Microsoft employee.

    Unfortunately, directly copying and pasting a formula cell containing hyperlinks as hyperlinks in Excel isn't possible. Excel's "Paste Values" option only captures the cell value itself, not the hyperlink functionality. This issue exists when copying between different Excel files or even within the same file.

    However, there are workarounds to achieve the desired behavior:

    Paste Special - Paste Link:

    This method creates a linked cell that dynamically updates whenever the source cell changes.

    Copy the formula cell containing the hyperlink. Switch to the target Excel file or sheet. Right-click the desired cell and choose

    I hope this helps ;-), let me know if this is contrary to what you need, I would still be helpful to answer more of your questions.

    Best Regards,

    AnnaThomas

    Give back to the community. Help the next person with this problem by indicating whether this answer solved your problem. Click Yes or No at the bottom.

    Was this answer helpful?

    0 comments