Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
File name insertion in cell
I have the =cell("filename",a1) formula, but what if you only what just the
file name and not the whole path??? This is driving me crazy, that I can't figure it out. Thank you Bonnie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
File name insertion in cell
File path, file and worksheet name:
=CELL("filename",A1) File path only: =LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1) File name only: =MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1) The sheet name: =MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255) More on this can found at Bob Phillips' site. http://www.xldynamic.com/source/xld.xlFAQ0002.html Gord Dibben MS Excel MVP On Thu, 22 Oct 2009 11:55:01 -0700, balterson wrote: I have the =cell("filename",a1) formula, but what if you only what just the file name and not the whole path??? This is driving me crazy, that I can't figure it out. Thank you Bonnie |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
File name insertion in cell
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)
-- Gary''s Student - gsnu200908 "balterson" wrote: I have the =cell("filename",a1) formula, but what if you only what just the file name and not the whole path??? This is driving me crazy, that I can't figure it out. Thank you Bonnie |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
File name insertion in cell
And check your other post, too.
balterson wrote: I have the =cell("filename",a1) formula, but what if you only what just the file name and not the whole path??? This is driving me crazy, that I can't figure it out. Thank you Bonnie -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell insertion in a sentence | Excel Discussion (Misc queries) | |||
Automatic Symbol Insertion In Cell | Excel Discussion (Misc queries) | |||
Disable cell reference insertion with PageUp in cell edit mode. | Excel Discussion (Misc queries) | |||
Cell insertion if values not matching | Excel Worksheet Functions | |||
Using a Cell Operation for insertion into a Formula | Excel Discussion (Misc queries) |