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

Need a little help in MS Excel guys....

Discussion in 'Black Hat SEO Tools' started by Ztak07, Feb 24, 2013.

  1. Ztak07

    Ztak07 Regular Member

    Joined:
    Jun 23, 2012
    Messages:
    389
    Likes Received:
    116
    I have a lot of data that I need to organize. I have a list of about 5k urls that I need to remove sub domains from. I used the text to collums method and seperated them with a period.


    My data looks like this

    A B C D
    =b1&"."c1&".d1" wdawdaw .co .uk

    As you can see collum a would produce: wdawdaw.co.uk, the problem I run into is I have 5000 rows and doing this manually would take some time. Does anyone know a method to speed it up? Because right now I had to adjust A= to the corresponding row number. Which means A2 has to equal b2, and c2, and d2 and so on for all 5000 rows.
     
  2. Standard Toaster

    Standard Toaster Regular Member

    Joined:
    Aug 29, 2009
    Messages:
    335
    Likes Received:
    190
    There's always a better way than "manual" in excel. But I don't quite understand you. A sample spreadsheet could help.
     
  3. Monkshood

    Monkshood Newbie

    Joined:
    Feb 24, 2013
    Messages:
    11
    Likes Received:
    8
    Select the cell with the working formula in it. Then drag the corner (I think there's a small black square in the bottom right) down to the bottom of your list. The formula will then modify itself to be applicable to each individual row.

    I can't post links yet, but Google "dragging formula down excel" and you'll get a lot of tutorials.

    Hope this helps.
     
    • Thanks Thanks x 1
  4. Ztak07

    Ztak07 Regular Member

    Joined:
    Jun 23, 2012
    Messages:
    389
    Likes Received:
    116
    but now if I want to get the data it outputs it gives me the formula and I cant copy it to a new sheet. it will display random.com but when I try to copy it only the formula copies for the specific cell.
     
  5. Monkshood

    Monkshood Newbie

    Joined:
    Feb 24, 2013
    Messages:
    11
    Likes Received:
    8
    Select everything in your Excel spreadsheet by clicking on any cell and pressing CTRL+A. Then copy it with CTRL+C and open a new file/sheet.

    When you paste it make sure to PASTE VALUES. There's an option in Excel to paste only the value which will paste the result of your formula, not the formula itself. Another quick Google will tell you how to paste values for your version of Excel.
     
    • Thanks Thanks x 1