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