dgd1212
asked on
Shippers tracking Number
When looking up a FedEx tracking number the URL format is:
="https://www.fedex.com/apps/fedextrack/?tracknumbers=TRACKING_NUMBER&cntry_code=us"
The TRACKING_NUMBER BEING A 12-15 digit.
I get a report with tracking numbers, lets say A1 contains a tracking number
If I do:
="https://www.fedex.com/apps/fedextrack/?tracknumbers="&VALUE(A1)&"&cntry_code
And then click the URL contains the "A1" and not the value of A1
Is it possible to get the actual number and not the cell location?
Thanks
="https://www.fedex.com/apps/fedextrack/?tracknumbers=TRACKING_NUMBER&cntry_code=us"
The TRACKING_NUMBER BEING A 12-15 digit.
I get a report with tracking numbers, lets say A1 contains a tracking number
If I do:
="https://www.fedex.com/apps/fedextrack/?tracknumbers="&VALUE(A1)&"&cntry_code
And then click the URL contains the "A1" and not the value of A1
Is it possible to get the actual number and not the cell location?
Thanks
ASKER
In the formula bar:
="https://www.fedex.com/apps/fedextrack/?tracknumbers="&VALUE(A1)&"&cntry_code
In the Cell (Hyperlink):
https://www.fedex.com/apps/fedextrack/?tracknumbers=012345678901&cntry_code=us
When above "clicked" and appearance in address bar:
https://www.fedex.com/apps/fedextrack/?tracknumbers=%22&VALUE(A1)&%22&cntry_code=us
How can I get: %22&VALUE(A1)&%22
to be: 012345678901
Thanks
="https://www.fedex.com/apps/fedextrack/?tracknumbers="&VALUE(A1)&"&cntry_code
In the Cell (Hyperlink):
https://www.fedex.com/apps/fedextrack/?tracknumbers=012345678901&cntry_code=us
When above "clicked" and appearance in address bar:
https://www.fedex.com/apps/fedextrack/?tracknumbers=%22&VALUE(A1)&%22&cntry_code=us
How can I get: %22&VALUE(A1)&%22
to be: 012345678901
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
="https://www.fedex.com/apps/fedextrack/?tracknumbers="&A1&"&cntry_code=us"
This should just display the contents of the cell A1.