miamitech305
asked on
Creating hyperlink within excel 2013 based on cell information
I have a spreadsheet that contains all my dell assets. One column has the dell services tags. I want to turn all the service tags in to hyperlinks to the following site.
http://www.dell.com/support/home/us/en/04/product-support/servicetag/<Service Tag>/maintain?ref=captchas een
How do i get this url to fill in the Service Tag based on the cell in excel 2013
http://www.dell.com/support/home/us/en/04/product-support/servicetag/<Service Tag>/maintain?ref=captchas
How do i get this url to fill in the Service Tag based on the cell in excel 2013
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
not sure what you mean, I'm afraid? could you post a sample sheet?
ASKER
http://www.dell.com/support/home/product-support/"DATA"
the "DATA" comes from the spreadsheet cell.