Last month I wrote about CELL function looks interesting but beware: language nightmares coming up….
There I mentioned both formulas from [Wayback/Archive] Get sheet name only – Excel formula | Exceljet and [Wayback/Archive] Insert the current Excel file name, path, or worksheet in a cell – Microsoft Support failing to deliver the expected results
an official Microsoft example of obtaining the Worksheet name which I suspected would not work on systems allowing ] in path names. And indeed it is true: that case fails on both MacOS and Windows in the same way.
Here you see the failures of both the ExcelJet function and the ones from Microsoft Support on two operating systems:
The Wiert Corner - irregular stream of stuff 