Prev: Average of a string containing multiple values
Next: Dropdown list data validation - word wrap
From: chuckie on 22 Feb 2010 10:42
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/community/en-us/default.mspx?&query=chuckie&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.excel.worksheet.functions&p=1&tid=fdc67c6c-72fb-4cc8-aadf-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
First  |  Prev  | 
Pages: 1 2
Prev: Average of a string containing multiple values
Next: Dropdown list data validation - word wrap