file path

[Guest]

I am trying to insert a file path from a word doc into a cell in an excel
spreadsheet. Then I want to take that cell and copy to another cell in the
same spreadsheet and have the second cell link back to the word document. Any
suggestions? (I also would rather not use vba)

 

[Guest]

=HYPERLINK("http://www.cnn.com","CNN")

Replace the CNN URL with your URL (filepath) and "CNN" with the name you
want to give the file.

See Excel's help for more info about HYPERLINK syntax.

Example: =HYPERLINK(http://www.cnn.com)

 

[Guest]

paste special as a LINK