I have a spreadsheet full of web page links that include both the domain and page. I want to strip the page information out and then I am going to use the remove duplicate feature to see the number of unique urls I am dealing with.
So the format is like this:
http://%rooturl%/%pageurl%
I believe the easiest way would be to just get everything before the 3rd "/", but I am not very good at Excel so I cant figure out how to do that. The %rooturl% will vary by size quite a bit.
Any help would be greatly appreciated.
Thanks,
Dave
So the format is like this:
http://%rooturl%/%pageurl%
I believe the easiest way would be to just get everything before the 3rd "/", but I am not very good at Excel so I cant figure out how to do that. The %rooturl% will vary by size quite a bit.
Any help would be greatly appreciated.
Thanks,
Dave