N
Norm
Is there a function to use the Tabname or sheetname in a cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Chip Pearson
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.
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
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?
S
shades
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
handy product.
http://longre.free.fr/english/index.html
It includes the function
=SHEETNAME()
also
=FILENAM