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