Return Tab Name into a specific cell

I am trying to find a solution to return the tab name of a sheet within a workbook to a particular cell.

What I have found is the following formula:

=MID(CELL("filename",L2),FIND("]",CELL("filename",L2))+1,255)

The above formula works fine until I put my file onto our server. The issue I have encountered is the naming of our particular job files (e.g. ..../Current Jobs/1234 [4321] - Job Description) the first number "1234" is the job number, the second number "[4321]" is the quote number followed by the "Job Description".

Now because we name our files this way and reference our quote number in "[]" square brackets it causes this formula to return all information after the first "]" closed square brackets.

Is there a different formula I could use or a way to modify the one that I am already using.

Thanks in advance.

You will need to find the second occurrence of the square bracket.

See if this link helps you;

https://www.extendoffice.com/documen...ccurrence.html

Thanks for the reply.

I have followed the link and this is what I came up with:

=MID(CELL("filename",L2),FIND("]",L2,FIND("]",L2)+2),CELL("filename",L2))+1,255))

but unfortunately is does not like that, I have obviously done it incorrectly.

Can you use square brackets in a filename?

Not in the file name but you can with folder names, hence my issue....

Try this;

Formula:

Please Login or Register  to view this content.

Worked a charm, thank you so much.