HYPERLINKING TO FEDEX TRACKING PAGE

[dadey]

Hello,

I have a spreadsheet that contains a whole list of fedex tracking numbers in one column.
What I would like to do is be able to hyperlink these numbers to the fedex tracking page.

the link for the tracking page is http://www.fedex.com/Tracking?tracknumbers=TRACKING NUMBER GOES HERE&cntry_code=us&clienttype=ivother&

what I am hoping to be able to do is to have a formula that would allow the value of a cell be plugged into a hyperlink going to the fedex tracking page.

Is this possible?

dave

 

[TrippyTom]

try this:
=HYPERLINK("http://www.fedex.com/Tracking?tracknumbers="&B1&"&cntry_code=us&clienttype=ivother&")

book1
	A	B	C	D	E	F	G	H	I
1	Tracking #:	123456789012345
2
3	Link:	http://www.fedex.com/Tracking?tracknumbers=123456789012345&cntry_code=us&clienttype=ivother&
Sheet1

 

[jkeller]

try this:
=HYPERLINK("http://www.fedex.com/Tracking?tracknumbers="&B1&"&cntry_code=us&clienttype=ivother&")

******** ******************** ************************************************************************><center>

Microsoft Excel - book1 ___Running: 11.0 : OS = Windows Windows 2000 <tbody> </tbody>
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout <form name="formCb059465"><input name="btCb290334" type="button" value="Copy Formula" *******='window.clipboardData.setData("Text",document.formFb543420.sltNb142651.value);'></form> <tbody> </tbody>
<select name="sltNb142651" onchange="document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value"><option value='=HYPERLINK("http://www.fedex.com/Tracking?tracknumbers="&B1&"&cntry_code=us&clienttype=ivother&")' selected="">B3</option></select> = <input name="txbFb965317" size="80" value='=HYPERLINK("http://www.fedex.com/Tracking?tracknumbers="&B1&"&cntry_code=us&clienttype=ivother&")'> <tbody> <form name="formFb543420"></form> </tbody>
	<center>A</center>	<center>B</center>	<center>C</center>	<center>D</center>	<center>E</center>	<center>F</center>	<center>G</center>	<center>H</center>	<center>I</center>
<center>1</center>	Tracking #:	123456789012345
<center>2</center>
<center>3</center>	Link:	[url]http://www.fedex.com/Tracking?tracknumbers=123456789012345&cntry_code=us&clienttype=ivother&[/URL]
Sheet1 <tbody> </tbody>

<tbody>
</tbody>

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</center>

I am looking to do something similar. But I would like to be able to do a couple things more. We ship a few different companies and have a column that we type vendor in Fed-Ex, UPS, and Conway. We specify in I1 who is shipping so I would like to be able to use the correct hyperlink for the vendor. Also I would like to be able to have it display as "Link" instead of the web address.

 

[Pam Sander]

Okay, the hyperlink works. Now how do I get it to return the status results back to my spreadsheet?