ExcelBanter - How to get file name on a worksheet?

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - How to get file name on a worksheet? (https://www.excelbanter.com/new-users-excel/71740-how-get-file-name-worksheet.html)

UNNI

How to get file name on a worksheet?

How to get just file name on a cell without .xls extenion ?

Anne Troy

How to get file name on a worksheet?

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

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"UNNI" wrote in message
...
How to get just file name on a cell without .xls extenion ?

Bob Phillips

How to get file name on a worksheet?

See http://www.xldynamic.com/source/xld.xlFAQ0002.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"UNNI" wrote in message
...
How to get just file name on a cell without .xls extenion ?

All times are GMT +1. The time now is 12:02 PM.