+ Reply to Thread
Results 1 to 2 of 2

How Do I Extract URLs from one set of cells and Insert into another set of cells

  1. #1
    Registered User
    Join Date
    10-01-2014
    Location
    TX
    MS-Off Ver
    Pro Plus 2010
    Posts
    1

    Exclamation How Do I Extract URLs from one set of cells and Insert into another set of cells

    Example:

    I have a worksheet in Excel 2010 Pro Plus that contains a list of "groups" and "pages" that I am a member of on a social media site.

    When I copied those names from the site, the paste function added the hyperlinks to the actual webpage associated with the group or page.

    Now I want to extract the URLs from the list of 20,000 items and insert those URLs into a different column.

    Instead of doing this manually (and going crazy), I would like to automate this process.

    I am not a programmer. While I can make Excel do lots of things, I am not a programmer. Nor do I pretend to be one.

    So, please post step by step as you would for a noob, using easy to understand language as you would for your grandmother.

    Thanks!

    DM
    Last edited by Leith Ross; 10-01-2014 at 06:57 PM. Reason: Removed Help ffrom the title Ttile

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Help!!! How Do I Extract URLs from one set of cells and Insert into another set of cel

    Hi DM,

    Welcome to the Forum!

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ 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. Need help with macro to automate web queries (with URLs in cells)
    By BBallExcel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-25-2013, 01:46 PM
  2. EXCEL VBA: web query from a list of URLs within cells
    By IDONTTELLYOU in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2012, 01:10 AM
  3. extracting URLs from cells and copying to another
    By RichAutechre in forum Excel General
    Replies: 2
    Last Post: 09-29-2011, 02:28 PM
  4. Generating urls in spreadsheet based on matching cells.
    By giallofever in forum Excel General
    Replies: 4
    Last Post: 03-05-2009, 12:47 PM
  5. HYPERLINK doesn't update urls when input cells change
    By sarah.k in forum Excel General
    Replies: 2
    Last Post: 03-04-2009, 01:53 PM

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