is there a Function/Formula that will put the name of the workshe.

R

RC

Is there a function key or formula that will put the name of the worksheet
into a cell on the same worksheet automatically?
 
J

Jay

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!
 
Top