P Paul Feb 20, 2004 #1 Is there an equivalent to =cell("filename",a1)which will display the name of the Excel sheet in a cell? Thanks for looking.
Is there an equivalent to =cell("filename",a1)which will display the name of the Excel sheet in a cell? Thanks for looking.
N Norman Harker Feb 20, 2004 #2 Hi Paul! You need to parse =CELL("filename",A1) Use: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) -- Regards Norman Harker MVP (Excel) Sydney, Australia (e-mail address removed) Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes.
Hi Paul! You need to parse =CELL("filename",A1) Use: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) -- Regards Norman Harker MVP (Excel) Sydney, Australia (e-mail address removed) Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes.
