File Name with no Sheet Name

**mrjackt** · 01-30-2014, 03:15 PM

how do i insert the file name only...cell=("filename") is good but i only want the file name not the sheet number

**JieJenn** · 01-30-2014, 03:44 PM

See if this works

=MID(CELL("filename"),FIND("[",CELL("filename"))+1,FIND("]",CELL("filename"))-FIND("[",CELL("filename"))-1)

**mrjackt** · 01-30-2014, 03:48 PM

I am sorry but i still need the full path of the file.

**JieJenn** · 01-30-2014, 03:53 PM

=LEFT(CELL("filename"),FIND("]",H26))

**mrjackt** · 01-30-2014, 04:01 PM

I am getting an #value error ?
Thanks again

**JieJenn** · 01-30-2014, 04:43 PM

Save your workbook first. If a workbook is not saved, it has no path directory.

**mrjackt** · 01-30-2014, 05:12 PM

Sorry still same error...what does the H26 stand for?
the cell to be reading on my workbook sheet is D5 to D7

**JieJenn** · 01-30-2014, 05:15 PM

It was a typo. The formula should be =LEFT(CELL("filename"),FIND("]",CELL("filename"))

**mrjackt** · 01-30-2014, 05:21 PM

That was it
thank you so much for your help

Re: File Name with no Sheet Name