Hey guys! Is it possible to make this?
I have a column with service tags like this:
DKP89MN
PQR1J4L
And I want to create hyperlinks for them but using their text like this:
http://www.dell.com/support/home/pro...rt/servicetag/ServiceTag/maintain?show_warranty_modal=true
I've tried this:
=HYPERLINK("http://www.dell.com/support/home/product-support/servicetag/"&A1&"/maintain?show_warranty_modal=true")
And it created the text correctly, but if I click on it, it says that the website doesn't exist.
Is there a way to do it?
Bookmarks