| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to retrieve number from filename?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to retrieve data from other filename? | Excel Discussion (Misc queries) | |||
| Retrieve filename question, again... | New Users to Excel | |||
| Number gets added to filename | Excel Discussion (Misc queries) | |||
| Retrieve Row index number | Excel Discussion (Misc queries) | |||
| number "1" added to filename | Excel Discussion (Misc queries) | |||
Threaded Mode
