Mass Remove Hyperlinks

Options

Is there a quick way to mass remove hyperlinks within specific columns on a Smartsheet? I do not want to "clear content", just remove the hyperlinks.

Best Answer

  • Emory
    Emory ✭✭✭✭
    Answer ✓

    Select the cells with the hyperlinks and Ctrl+C (Copy)
    Right-click the same cells and Paste Special —> Values.

    Alternatively, you could export the sheet to excel, remove the hyperlinks there, and then copy/paste the column back to the sheet in smartsheet.

    Hope this helps!

Answers

  • Emory
    Emory ✭✭✭✭
    Answer ✓

    Select the cells with the hyperlinks and Ctrl+C (Copy)
    Right-click the same cells and Paste Special —> Values.

    Alternatively, you could export the sheet to excel, remove the hyperlinks there, and then copy/paste the column back to the sheet in smartsheet.

    Hope this helps!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!