Luke M:

This works very well, however, I tried copy/save value and it shuts down the
'hyperlink'. The cell is still highlighted and underlined, just not
clickable. As I said to Eduardo, I think I will try them and then 'hide' the
unnecessary column(s). Any ideas how to keep the hyperlink active after
copy/save value?
--
chuck


"Luke M" wrote:

If the tracking number is in cell A2, could do:
=HYPERLINK("http://www.fedex.com/Tracking?cntry_code=us"&J1,J1)

Check your other post to see other ways of concatenating url's w/ the
tracking numbers.
http://www.microsoft.com/office/comm...f-d92f3273cc1f
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"chuckie" wrote:

I am trying to insert a 'hyperlink' into a spreadsheet. The URL I'm using
is: http://www.fedex.com/Tracking?cntry_code=us and I would like Excel to
add the contents of the cell to the URL. This is for tracking purposes in
FedEx, and I would like to send our customer a spreadsheet wherein they could
click on the tracking number (the contents of the cell in question) and view
the tracking information. Using the formula;
=hyperlink("http://www.fedex.com/Tracking?cntry_code=us,j1) simply puts you
at the FedEx tracking screen and the tracking number isn't added to the
equation. Anybody know of any way to get the formula to add the tracking
number to the Url?
--
chuck