C Chip Pearson Jan 9, 2004 #2 Norm, Use the following formula: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99) The file must have been saved for this to work.
Norm, Use the following formula: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99) The file must have been saved for this to work.
N Norm Jan 9, 2004 #3 Thx chip Chip said: Norm, Use the following formula: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99) The file must have been saved for this to work. Is there a function to use the Tabname or sheetname in a cell? Click to expand... Click to expand...
Thx chip Chip said: Norm, Use the following formula: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99) The file must have been saved for this to work. Is there a function to use the Tabname or sheetname in a cell? Click to expand... Click to expand...
S shades Jan 9, 2004 #4 There is a free add-in (in either English or French) call morefunc. Ver handy product. http://longre.free.fr/english/index.html It includes the function =SHEETNAME() also =FILENAM
There is a free add-in (in either English or French) call morefunc. Ver handy product. http://longre.free.fr/english/index.html It includes the function =SHEETNAME() also =FILENAM
