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

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.

There's always a better way than "manual" in excel. But I don't quite understand you. A sample spreadsheet could help.

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.

Monkshood said:

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.

Click to expand...

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.

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.