+ Reply to Thread
Results 1 to 4 of 4

Combine text from two cells into a working hyperlink

Hybrid View

  1. #1
    Registered User
    Join Date
    10-27-2018
    Location
    Norway
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    4

    Combine text from two cells into a working hyperlink

    Hi all.

    I'm looking for a solution on the following challenge.
    In my work I sometimes need to collect documentation on various products. There is one particullar web site I use for that and the look up address for documentation is fairly simple, as the only thing that changes is the product number.
    I have attached an Excel workbook for reference.

    So, if the product number is 8063060, the look up address will be like the one in cell D7 in the attached example workbook
    In my Excel workbook I import the numbers from other systems and put them in one row, then I want one cell (on each row with product numbers) to add the product number after the = as per cell C3, C4 and C7 in the attached workbook. I have managed to have this done, but I'm not getting a clickable link (see the example workbook). Any one up for a challenge to help me out?

    Best regards
    Jonny
    Attached Files Attached Files

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,765

    Re: Combine text from two cells into a working hyperlink

    Formula: copy to clipboard
    =HYPERLINK(C7&B7,"info about product: "&B7)


    Check attached file.
    Attached Files Attached Files
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Registered User
    Join Date
    10-27-2018
    Location
    Norway
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    4

    Re: Combine text from two cells into a working hyperlink

    Hi Kokosek

    Thanks for your reply.

    Your solution solved my problem.. Brilliant

    Best regards
    Jonny

  4. #4
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,765

    Re: Combine text from two cells into a working hyperlink

    Happy to help.
    Thanks for rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need to combine cells to one string of text if duplicate values exist in multiple cells
    By Chris McGlothen in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-17-2017, 09:13 PM
  2. Combine text from multiple cells based on criteria from other cells
    By t2cool in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-07-2017, 12:03 PM
  3. Replies: 2
    Last Post: 04-08-2015, 08:10 AM
  4. [SOLVED] Combine multiple cells text into one cell, skip blank cells.
    By T15K in forum Excel General
    Replies: 6
    Last Post: 12-05-2014, 09:49 PM
  5. Combine multiple text cells if value exists in other cells
    By epoch555 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-22-2014, 03:50 PM
  6. Combine text in cells
    By simoninman in forum Excel General
    Replies: 1
    Last Post: 06-23-2009, 11:06 PM
  7. [SOLVED] Combine Hyperlink with Text
    By Lee Swain in forum Excel General
    Replies: 1
    Last Post: 05-04-2006, 06:15 AM

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