Excel users - need help!

[Lace]

I have 3,000+ items in column A. This column has urls. Within the urls are numerical ID's which I need to extract and place into column B.

The ID's are like this - site.com/blah/2091/index.html. So, column B would only show 2091.

I know there has to be an easy way to do this. Anyone?

[Lace]

Ah, got it using text to columns.

[Coup]

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'

[Barry-xlovecam]

'/' is the delimiter like the , in a CSV ...

[Paul&John]

I would just do that in notepad++ using regex