| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display file name without the file type extension
Is it possible to return the file name value to a cell without the '.xlsx'?
Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display file name without the file type extension
Try the below in a saved workbook.
=TRIM(LEFT(SUBSTITUTE(MID(CELL("filename",A1), FIND("[",CELL("filename",A1))+1,255),".xl",REPT(" ",255)),255)) If this post helps click Yes --------------- Jacob Skaria "NAHolmes" wrote: Is it possible to return the file name value to a cell without the '.xlsx'? Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display file name without the file type extension
This worked perfectly - many thanks.
"Jacob Skaria" wrote: Try the below in a saved workbook. =TRIM(LEFT(SUBSTITUTE(MID(CELL("filename",A1), FIND("[",CELL("filename",A1))+1,255),".xl",REPT(" ",255)),255)) If this post helps click Yes --------------- Jacob Skaria "NAHolmes" wrote: Is it possible to return the file name value to a cell without the '.xlsx'? Thanks. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display file name without the file type extension
Try this:
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-6) Keep in mind that the "filename" used with CELL() does not return anything until the workbook has been saved. or if you definitely know that the filename ends with .xlsx (and not .xlsm or other Excel 2007 file type identifier), then this would work: =MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND(".xlsx]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1) "NAHolmes" wrote: Is it possible to return the file name value to a cell without the '.xlsx'? Thanks. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display file name without the file type extension
This also worked, again - many thanks.
"JLatham" wrote: Try this: =MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-6) Keep in mind that the "filename" used with CELL() does not return anything until the workbook has been saved. or if you definitely know that the filename ends with .xlsx (and not .xlsm or other Excel 2007 file type identifier), then this would work: =MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND(".xlsx]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1) "NAHolmes" wrote: Is it possible to return the file name value to a cell without the '.xlsx'? Thanks. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display file name without the file type extension
This is a great resource:
http://www.mcgimpsey.com/excel/formu..._function.html HTH, Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "NAHolmes" wrote: This also worked, again - many thanks. "JLatham" wrote: Try this: =MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-6) Keep in mind that the "filename" used with CELL() does not return anything until the workbook has been saved. or if you definitely know that the filename ends with .xlsx (and not .xlsm or other Excel 2007 file type identifier), then this would work: =MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND(".xlsx]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1) "NAHolmes" wrote: Is it possible to return the file name value to a cell without the '.xlsx'? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determine Excel file version with no file extension. | Excel Discussion (Misc queries) | |||
| file format or file extension is not valid...error message | Excel Discussion (Misc queries) | |||
| Cannot download exel spreadsheet file with extension type xls | Excel Worksheet Functions | |||
| Additional file with no extension created during File Save As proc | Excel Discussion (Misc queries) | |||
| I need to download an exel spreadsheet file. (file extension :xls) | Excel Discussion (Misc queries) | |||
Hybrid Mode
