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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
Function to Insert Text Into a Formula 3
Needs help combining functions. 3
Use TODAY() function as the criteria in a SUMIF formula 1
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Newbie Help - IF Yes No Function 0
Trying To Put IFs into a Function 3

Top