Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display filename in cell
Hi,
I was using the ' =Cell("Filename") ' function in excel, But I want to display only the path "= C:\Folder1\Folder2\" And then I want to display the worksheet name = "worksheet1" Is there a way to do this? THanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display filename in cell
Path is
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1) Sheet name is =MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255) more here http://www.xldynamic.com/source/xld.xlFAQ0002.html -- Allllen "Jeff" wrote: Hi, I was using the ' =Cell("Filename") ' function in excel, But I want to display only the path "= C:\Folder1\Folder2\" And then I want to display the worksheet name = "worksheet1" Is there a way to do this? THanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display filename in cell
This will return the worksheet name:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) and this will return the folder: =MID(CELL("filename",A1),1,FIND("[",CELL("filename",A1))-1) Jeff wrote: Hi, I was using the ' =Cell("Filename") ' function in excel, But I want to display only the path "= C:\Folder1\Folder2\" And then I want to display the worksheet name = "worksheet1" Is there a way to do this? THanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
substitute the filename in a cell reference with a string in another cell. | Excel Discussion (Misc queries) | |||
display a drop-down list based on the content of another cell | Excel Discussion (Misc queries) | |||
Display text 1024 characters in a cell | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |