is there a Function/Formula that will put the name of the workshe.
Is there a function key or formula that will put the name of the worksheet
into a cell on the same worksheet automatically? |
No function key, but, there is a formula. It looks like the following, simply
copy and paste it into any cell as is, okay! Here it is: =MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1) Hope this helps! "RC" wrote: Is there a function key or formula that will put the name of the worksheet into a cell on the same worksheet automatically? |
Check out
http://www.mcgimpsey.com/excel/formu..._function.html In article , "RC" wrote: Is there a function key or formula that will put the name of the worksheet into a cell on the same worksheet automatically? |
All times are GMT +1. The time now is 11:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com