OBJECTIVE
Trying to build an excel sheet with Shipments for the day from the
database. I am trying to include UPS tracking number as a HyperLink to the
UPS website.
I build the link and fill the colum using HYPERLINK function of excel

THE PROBLEM
Eg: This is a sample link i am trying to write to the colum from the database

=HYPERLINK("http://wwwapps.ups.com/tracking/tracking.cgi/?tracknum=1Z1516306601513843","Track Shipment")

What happens is when the data is loaded, Excel prefix a single quote (') to
the begining of the expression, hence the function doesnt work and the link
is not active
This how it shows up in excel

'=HYPERLINK("http://wwwapps.ups.com/tracking/tracking.cgi/?tracknum=1Z1516306601513843","Track Shipment")

I notice that excel does add sigle quote to all the character fields coming
from the database..
QUESTION
1) How can I suppress this single quote?
2) If it cannot be suppressed, how can i remove this after the the data is
loaded? Can i use a macro? ( i dont have much experience in this area). If
yes, how?
3) Or is there any alternate approach to get to the objective

Any help would be greatly appreciated.
(Sujith
ChestNut Ridge, NY)