How to get just file name on a cell without .xls extenion ?
A Anne Troy Feb 15, 2006 #2 =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
=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
B Bob Phillips Feb 15, 2006 #3 See http://www.xldynamic.com/source/xld.xlFAQ0002.html -- HTH Bob Phillips (remove nothere from email address if mailing direct)
See http://www.xldynamic.com/source/xld.xlFAQ0002.html -- HTH Bob Phillips (remove nothere from email address if mailing direct)
