The formula looks like an answer to a specific question, what the original
question was is hard to say. It's series of text fomulas doing something,
not sure what!
What are you trying to achieve? You mention naming tabs, if you mean sheet
tabs, you can only do that manually or with VB code, a formula can't do
that.
Post back explaining what you want to do, I'm sure you'll get answers,
Regards,
Alan.
"SharonJo" wrote in message
...
I saw a previous question for this, but I need help understanding the
formula.
I tried coping this formula, into A1, but--what do I need to change?
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename",A 1))-FIND("]",CELL("filename",A1)))