-
Solved: Change text to hyperlink
Hi. I hope someone is kind enough to assist.
I am trying to convert the text from one column to a hyperlink in the next column.
eg. If in cell A1, I have the text link.doc, I would like a hyperlink to be created in B1 with the hyperlink link.doc.
So as long as there is a file named link.doc in the same directory as my spreadsheet, clicking on the new hyperlink in B1 would open the file.
I hope I have explained that clearly. I would be grateful for any assistance.
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules