I disagree. The cell reference should be included in the second part as well. If not, that blue part will return the file name of the most recent file that was calculatedfile in which the most recent cell was changed** and that may not be the file this formula is in. Therefore the FIND() in this formula could be finding the position of the "]" in the wrong file name.
On a side note, the issue of 255 v 31 could also be resolve by using REPLACE instead.
The CELL function syntax has the following arguments:
A text value that specifies what type of cell information you want to return. The following list shows the possible values of the Info_type argument and the corresponding results.
The cell that you want information about. If omitted, the information specified in the info_type argument is returned for the last cell that was changed. If the reference argument is a range of cells, the CELL function returns the information for only the upper left cell of the range.
I disagree. The cell reference should be included in the second part as well. If not, that blue part will return the file name of the file in which the most recent cell was changed**
** From the CELL function Help
It doesn't matter, the name of the file doesn't matter, it's always going to end with the "]" character. We do not look for the name of the book, we look for the name of the sheet. At least in this thread.
Also with the following we save second parts.
To achieve this I opened file "Test1" that contains several sheets including this Sheet2 shown above. At that point A1 and A2 both showed 'Sheet2'.
I then opened another file "Testing2" and on 'Sheet5' in that workbook I entered a value in a cell. Cell A2 in Test1/Sheet2 changed from Sheet2 to what you see above. Does that not happen for you?