Results 1 to 5 of 5

Question about hyperlinks

Threaded View

  1. #1
    Registered User
    Join Date
    01-10-2013
    Location
    Brazil
    MS-Off Ver
    Excel 2013
    Posts
    15

    Question Question about hyperlinks

    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?
    Attached Files Attached Files
    Last edited by AliGW; 02-06-2020 at 08:18 AM. Reason: Irrelevant section of title removed.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Newbie Question
    By Pete B in forum Excel General
    Replies: 2
    Last Post: 02-26-2021, 03:20 PM
  2. Newbie question - what does this mean?
    By itsfine in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-21-2012, 11:52 AM
  3. Newbie question
    By Barry Clark in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-12-2006, 03:40 PM
  4. Replies: 3
    Last Post: 05-05-2006, 12:55 PM
  5. Question from A Newbie
    By akafrog18 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-30-2006, 08:09 AM
  6. RE: Newbie With A Question
    By Michael in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-28-2005, 07:05 PM
  7. Newbie with newbie question
    By elgrandekazoo in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 03-28-2005, 02:13 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1