Here is one way

=MID(CELL("FILENAME",A1),FIND("]",CELL("FILENAME",A1))+1,225)
--
Mike Q.


"Joe" wrote:

I have a formula that is trying to take for example the word "Hello" from a
worksheet tab. Is that even possible?

Thanks!!