Forum Discussion
Solved
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 fo...
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.
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.