Does anyone have any suggestions on how to retrieve the number from filename?

Let assume that only 1 number existed within each filename, which could be
any number from 0 to 1000, such as "Eric - UP 4 R.xls". I would like to
remove all characters of the filename except the number, and return this
number into cell A2.

Does anyone have any suggestions?
Thank anyone for any suggestions
Eric