|
if all the urls are in the same
site.com/blah/####/index.html
format I would find for "site.com/blah/" and "/index.html" and replace them all with nothing in notepad or something. You'll be left with just the numbers. Then just copy and paste them into column 'B'
|