Just wrap your concatenate formula in hyperlink(), like this: =HYPERLINK(CONCATENATE(A1,B1))
HTH, Will Sansbury > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Lisa Gielczyk (TCP) > Sent: Thursday, January 24, 2008 11:17 AM > To: email > Subject: [TCP] hyperlinks in Excel > > Hello everyone, > > I'm hoping there might be an Excel guru or two in our midst. :) > > Yesterday, I found a neat little tool to create an Excel > spreadsheet list of all the files in a directory > (http://www.finrepinc.com/prod02.htm). In this instance, it > produced a spreadsheet with over 3500 lines. Of the columns I > am using, one has the filename, the other has the directory > path. I set up the next column to concatenate the two > columns, so that I have the full path. What I'd like now is > to hyperlink each full path, so that if I want to compare two > documents in the list, I only have to click on their links in > the spreadsheet. > > I've searched Google, but so far, I've not found what I'm > looking for. Any ideas? > > Thanks! > Lisa G. > ______________________________________________ > > Author Help files and create printed documentation with Doc-To-Help. > New release adds Team Authoring Support, enhanced Web-based > help technology and PDF output. Learn more at www.doctohelp.com/tcp. > > > Interactive 3D Documentation > Parts catalogs, animated instructions, and more. > www.i3deverywhere.com _______________________________________________ > > Technical Communication Professionals > > Post a message to the list: email [EMAIL PROTECTED] > > Subscribe, unsubscribe, archives, account options, list info: > http://techcommpros.com/mailman/listinfo/tcp_techcommpros.com > Subscribe (email): send a blank message to > [EMAIL PROTECTED] Unsubscribe (email): send a > blank message to [EMAIL PROTECTED] > > Need help? Contact [EMAIL PROTECTED] > > Get the TCP whole experience! http://www.techcommpros.com > ______________________________________________ Author Help files and create printed documentation with Doc-To-Help. New release adds Team Authoring Support, enhanced Web-based help technology and PDF output. Learn more at www.doctohelp.com/tcp. Interactive 3D Documentation Parts catalogs, animated instructions, and more. www.i3deverywhere.com _______________________________________________ Technical Communication Professionals Post a message to the list: email [EMAIL PROTECTED] Subscribe, unsubscribe, archives, account options, list info: http://techcommpros.com/mailman/listinfo/tcp_techcommpros.com Subscribe (email): send a blank message to [EMAIL PROTECTED] Unsubscribe (email): send a blank message to [EMAIL PROTECTED] Need help? Contact [EMAIL PROTECTED] Get the TCP whole experience! http://www.techcommpros.com
