Excel 2007 : Obtain number from web link

Hi All,

Need a little help here.

I have data in the following format -

http://www.friends.com/general/hobbies/123456-Andrea Timothy.html
http://www.friends.com/crafts/234344-John Samuel.html

This runs into several rows. How do i obtain just the numbers like 234344 and 123456 in a separate column? Text to columns doesn't work in this case.

Thanks much.