-To obtain the sheetname all in one formula:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)-
What is the significance of 255? Is that the limit for number of
characters the formula will look at? Could I use 355 and get a
different result, if the string had that many characters?
--
LACA
------------------------------------------------------------------------
LACA's Profile:
http://www.excelforum.com/member.php...o&userid=30381
View this thread:
http://www.excelforum.com/showthread...hreadid=544020