J1 contains the tracking number?
=hyperlink("http://www.fedex.com/Tracking?cntry_code=us,"&j1,"click me")

The formula you posted wasn't correct in a couple of different ways. I'm not
sure what you really tried in your worksheet.



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

--

Dave Peterson