+ Reply to Thread
Results 1 to 5 of 5

Formula for adding content to the end of a link

  1. #1
    Registered User
    Join Date
    03-01-2021
    Location
    Ipswich
    MS-Off Ver
    Google Sheets
    Posts
    44

    Formula for adding content to the end of a link

    Hi all,

    Is there a formula or function that I can use to add a url from column a to the end of the link in column b?

    For example in column A i have 1stReality.com and in column B i have https://dan.com/orders/checkout/

    How do i get all rows to show the last part with the url like this > https://dan.com/orders/checkout/1stReality.com
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,147

    Re: Formula for adding content to the end of a link

    Try this;

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-01-2021
    Location
    Ipswich
    MS-Off Ver
    Google Sheets
    Posts
    44

    Re: Formula for adding content to the end of a link

    Quote Originally Posted by Haluk View Post
    Try this;

    Please Login or Register  to view this content.
    It worked. Thank you very much

  4. #4
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Formula for adding content to the end of a link

    another method you can consider... by just having the list in column A, (and deleting your existing column B), in B1 you can put this:
    Please Login or Register  to view this content.
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

  5. #5
    Registered User
    Join Date
    03-09-2022
    Location
    Canada
    MS-Off Ver
    google sheets
    Posts
    5

    Re: Formula for adding content to the end of a link

    please delete this post, I did a mistake
    Last edited by georgeausters11; 03-09-2022 at 04:19 PM.

+ 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. Formula cell needed -> link to variable external link based on a cell content
    By milea_sorin in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-22-2018, 10:00 AM
  2. Link a cell to a specific content
    By pedrofilipegomes in forum Excel General
    Replies: 0
    Last Post: 09-17-2015, 10:18 AM
  3. Replies: 1
    Last Post: 05-17-2014, 03:30 PM
  4. Paste link function and formula for adding up dates as a total number
    By regional1500 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-19-2013, 11:57 PM
  5. [SOLVED] Excel 2007 : Link combo box content
    By mrjinx007 in forum Excel General
    Replies: 1
    Last Post: 07-03-2012, 10:05 AM
  6. link cell content to another file
    By blackstar in forum Excel General
    Replies: 2
    Last Post: 04-03-2006, 10:25 PM
  7. how do I link tab name to content of a cellt?
    By MadMurr in forum Excel General
    Replies: 6
    Last Post: 10-17-2005, 11:05 AM

Tags for this Thread

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