1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Add hyperlinks to multiple cells

I have an ID column containing numbers. And I have another column containing a unique URL which opens the relevant ID in our internal system.

Is there a way to add those links to the cells in the ID column, rather than have a separate URL column?

There are several thousand so do t want to do them manually!

submitted by /u/Iminawideopenspace
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#hyperlinks
#ID column
#URL
#unique URL
#internal system
#Excel
#manual
#cells
#column
#numbers
#relevant ID
#separate URL column
#thousands
#submission
#automate
#data
Add hyperlinks to multiple cells