| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Filename without dir & sheet name
Tried =cell("filename",ref) but could not find how to remove the entire
directory and the worksheet name. I only require the .xls filename without the sheet name. ie. "c:\..\Template.xls[worksheet]" becomes "Template" only. Excel help no help and searched here but nothing appeared similar. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Filename without dir & sheet name
See
http://www.xldynamic.com/source/xld.xlFAQ0002.html -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Alchemist" wrote in message ... Tried =cell("filename",ref) but could not find how to remove the entire directory and the worksheet name. I only require the .xls filename without the sheet name. ie. "c:\..\Template.xls[worksheet]" becomes "Template" only. Excel help no help and searched here but nothing appeared similar. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Filename without dir & sheet name
Here's one way:
=MID(CELL("FILENAME",A1),FIND("[",CELL("FILENAME",A1))+1,FIND("]",CELL("FILENAME",A1))-FIND("[",CELL("FILENAME",A1))-5) HTH, Smitty "Ron de Bruin" wrote: See http://www.xldynamic.com/source/xld.xlFAQ0002.html -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Alchemist" wrote in message ... Tried =cell("filename",ref) but could not find how to remove the entire directory and the worksheet name. I only require the .xls filename without the sheet name. ie. "c:\..\Template.xls[worksheet]" becomes "Template" only. Excel help no help and searched here but nothing appeared similar. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically printing to PDF with the filename as the sheet name | Excel Discussion (Misc queries) | |||
| Need help, Seq numbers, Save filename & A button on sheet. | Excel Discussion (Misc queries) | |||
| hyperlink to sheet in formula, can't save under new filename | Excel Worksheet Functions | |||
| Is there an automatic display/print the filename on sheet in Exce. | Excel Discussion (Misc queries) | |||
| vlookup and filename returning same result on each sheet. | Excel Discussion (Misc queries) | |||
Linear Mode
