Insert Tabname Into a Cell

September 22nd, 2004 | Categories: Formulas | Tags:
-->

A formula to insert the tabname in a cell in excel:

=MID(CELL(“filename”,A1),SEARCH(“]”,CELL(“filename”,A1))+1,LEN
(CELL(“filename”,A1))-SEARCH(“]”,CELL(“filename”,A1)))

Note: Remove the line break from the formula in Excel.

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
Leave a comment | Trackback
  1. Nick Paling
    October 16th, 2004 at 02:44
    Reply | Quote | #1

    hi,

    =RIGHT(CELL(“filename”,A1),LEN(CELL(“filename”
    ,A1))-SEARCH(“]”,CELL(“filename”,A1)))
    is a slightly less complex method of achieveing the same result