Forum Discussion
Turn column of formula based text into hyperlinks
Hi. I have a spreadsheet with one column that has a formula to define a file based hyperlink.
The hyperlink selects the folder path from cell "W1" containing something like "E:\NZ Camera"
The formula in the column looks like "="\\"&X$2&"\"&L3&".jpg" and produces something like
"\\E:\NZ Camera\My Image.jpg"
I want to convert that into text as a hyperlink without having to edit all cells.
I have tried copying the column result and pasting it as Values but i can't find a way of easerly converting it into a hyperlink to the image file.
Once i have this working, i want to send the spreadsheet to 4 judges who can then enter the location of the files in "W1" and press a button to provide the hyperlink.
Any help kindly appreciated.
John
Try using the formula: (AB1 is a random cell that might have the name of the text to be displayed)
=HYPERLINK(W1,AB1)if you could provide a sample data with more details of what you need as the output I could probably help you better.
2 Replies
Try using the formula: (AB1 is a random cell that might have the name of the text to be displayed)
=HYPERLINK(W1,AB1)if you could provide a sample data with more details of what you need as the output I could probably help you better.
Thanks for that, it works exactly how i wanted it.
