How tab names are separated underneath the hood in Excel? Using FIND function

[Vitale]

Hello!

I have found an interesting thread here, in which this formula is used:

=INDEX(MID(SheetNames,FIND("]",SheetNames)+1,255),ROWS(A$1:A1))
https://www.mrexcel.com/forum/excel-questions/428957-list-worksheet-names-using-formula.html

SheetNames is the name of the whole Workbook, if I understood that correctly.
Please, let me know if I correct understand the following:

MID function looks at the whole SheetNames workbook, and finds tab names next to the current sheet with FIND("]",SheetNames)+1.

If this is correct, then do I understand correctly that tab names in Excel are surrounded by square brackets, and hence "]" indicates the end of the first (currently opened) sheet's name, thus guiding the FIND function to the end of that name, and + 1 allows to get to the second name?

Thank you very much!

 

[BarryL]

like using =CELL("filename") it will return [workbookname.xls]sheetname

the find gives the number of charcters before the ] including the ]. the +1 goes onto the first letter of the sheet name. 255 is the number of characters that will capture the whole sheet name.

then rows(A$1:A1) will equal 1 then as you drag it down it will be A1:A2...A1:A3 thus 2 then 3, this gives you the first second and third value in the sheet names

 

[Vitale]

like using =CELL("filename") it will return [workbookname.xls]sheetname

the find gives the number of charcters before the ] including the ]. the +1 goes onto the first letter of the sheet name. 255 is the number of characters that will capture the whole sheet name.

then rows(A$1:A1) will equal 1 then as you drag it down it will be A1:A2...A1:A3 thus 2 then 3, this gives you the first second and third value in the sheet names

Thank you very much! It is all clear now.