| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to extract a filename?
a cell contains:
C:\Program Files\Amersham Biosciences\ImageMaster 2D Platinum Trial\Gels\94-0005.mel How to obtain 94-0005 in this case? certainly, the path can also be d: and the filename is of any combinations of characters in general. i find "FIND, MID, MATCH, RIGHT, ..." doesn't do a good job, thx!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 Question: Coloumn width, Filename | Excel Worksheet Functions | |||
| extract numbers, convert to date | Excel Discussion (Misc queries) | |||
| Extract specific data into its own workbook via macro? | Excel Discussion (Misc queries) | |||
| How do I join a filename and a cellreference, by just filling in . | Excel Worksheet Functions | |||
| Insert value of a cell as a filename | Excel Worksheet Functions | |||
Threaded Mode
