1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[Excel Question] Combine column of text with column of links?

Discussion in 'Black Hat SEO Tools' started by Ampix0, Jan 16, 2014.

  1. Ampix0

    Ampix0 Power Member

    Joined:
    Jan 10, 2012
    Messages:
    525
    Likes Received:
    60
    Home Page:
    Is it possible to create the following situation?

    In Excel:

    Col A...............ColB
    Google, Inc http://www.google.com

    Can these columns be combined into a single column like so:

    Google, Inc

    I would need to shift all of the links on the right and merge with all of the text in the column to the left of it.
     
  2. christoss1959

    christoss1959 Senior Member

    Joined:
    Nov 25, 2010
    Messages:
    894
    Likes Received:
    1,150
    Home Page:
  3. Ampix0

    Ampix0 Power Member

    Joined:
    Jan 10, 2012
    Messages:
    525
    Likes Received:
    60
    Home Page:
    That directly no, but I read the comments and apparently I can copy the url column and "paste as hyper link" as soon as the scrape finishes I will take a look at that.