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.