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.


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