Hyperlinks and Laziness

RaviWildcat

Board Regular
Joined
Jun 18, 2010
Messages
91
Hi Everyone - I've got about 300 cells that need hyperlinks added

The cells all have the same format - The value is PI-XXXX and the hyperlink is https:\\I-am-lazy\PI-XXXX

In a perfect world I'd simply create a helper column using the hyperlink function, but I"ve been specifically instructed not to include functions in the final report (it feels like my hands are tied!)

I can use the hyperlink function to create the actual links, but when I copy and paste the values - the hyperlinks don't get copied as well


I'm lazy and I really don't want to double click on each cell, edit hyperlinks, add the hyperlink and then save, then repeat 300 times

Any suggestions?

Thanks,
Ravi
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Watch MrExcel Video

Forum statistics

Threads
1,109,537
Messages
5,529,424
Members
409,875
Latest member
Khushal Bisht
Top