How to pull information out of a cell

Hi,

I was wondering if there was a way to pull something out of a cells contents and put it into another cell.

Here is what I'm trying to do. I have a cell with information like the following (the x's are text)

2004 xxxxxxxxxx #54 xxxxxxxxxxxxxx

What I need to do is be able to take the 54 out and place it in another cell. The text between the year and number varies as well as the text after the number.

Any help would be greatly appreciated.

Ed