Hi,
URL is in cell A10 and trucking number in A11

=A10&","&A11

then copy the above result as value

"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

Eduardo:

This works only if preceeded by the '=hyperlink' formula, copy/save value
removes the hyperlink (clickable) quality, thereby rendering it useless. I
will try it and 'hide' the other columns. Thank you for the reply...
--
chuck


"Eduardo" wrote:

Hi,
URL is in cell A10 and trucking number in A11

=A10&","&A11

then copy the above result as value

"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