On Fri, 14 Dec 2007 21:16:00 -0800, Eric
wrote:

Thank you for your suggestions

I would like to remove all characters of the filename, only keep the number,
and return this number into cell A2.
Let assume that only 1 number existed in each filename, which could be any
number from 0 to 1000.
Does anyone have any suggestions?
Thank anyone for any suggestions
Eric

Instead of just repeating your question, it would be more useful if you would
post what happened after you tried my suggestion, and why the result was
unsatisfactory.

There is no way for me to figure out the problem with my suggestion when you
don't post any additional detail.


--ron