| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting only the filename with no extension
This code Code: -------------------- =MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1) -------------------- works almost perfect for my needs; however, I need it to drop the extension to where only the name of the name of the file is left. Any thoughts? Thanks! -- Barry Clark ------------------------------------------------------------------------ Barry Clark's Profile: http://www.excelforum.com/member.php...o&userid=35267 View this thread: http://www.excelforum.com/showthread...hreadid=555713 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatinate a filename | Excel Discussion (Misc queries) | |||
| filename pointer | Excel Worksheet Functions | |||
| Transformation d'images avec une extension .jpg ou .jpeg en images avec extension .bmp ou .ico | Excel Discussion (Misc queries) | |||
| Filename at the very top of Microsoft Excel Window | Excel Discussion (Misc queries) | |||
| Insert value of a cell as a filename | Excel Worksheet Functions | |||
Threaded Mode
