Filename in cell without CELL function

[kcmuppet]

Does anyone know how to get the filename in cell without using the CELL function (so that it can work if the file is opened in Sharepoint)?

It turns out (see here) we can get the sheet name in a cell using something like below as as a named reference, e.g. 'GetSheetName' and then =GetSheetName(Sheet1!A1) in a cell:

=LAMBDA(refCell, LET(frmTxt, FORMULATEXT( INDIRECT( ADDRESS(ROW(),COLUMN()) ) ), SUBSTITUTE(TEXTAFTER( TEXTBEFORE(frmTxt,"!",[B]-1[/B]), "(", -1), "'", "") ))('Sheet1 Copy'!A1)

I was wondering if anyone knows how to do something similar for the file name?

 

[felixstraube]

Maybe it is just me, but that formula doesn't seem to be working.

Also the LAMBDA variable "refCell" is never used.

 

[kcmuppet]

Actually it should be:

=LAMBDA(refCell, LET(frmTxt, FORMULATEXT( INDIRECT( ADDRESS(ROW(),COLUMN()) ) ), SUBSTITUTE(TEXTAFTER( TEXTBEFORE(frmTxt,"!",[B]-1[/B]), "(", -1), "'", "") ))

 

[felixstraube]

That doesn't seem to be a valid formula either.

 

[kcmuppet]

That doesn't seem to be a valid formula either.

It's explained in the thread in the link in the first post

 

[Fluff]

The formula is

=LAMBDA(refCell, LET(frmTxt, FORMULATEXT( INDIRECT( ADDRESS(ROW(),COLUMN()) ) ), SUBSTITUTE(TEXTAFTER( TEXTBEFORE(frmTxt,"!",-1), "(", -1), "'", "") ))

@kcmuppet if you want to format a formula please use the "rich" code tags & not the "xls" tags.

 

[kcmuppet]

@kcmuppet if you want to format a formula please use the "rich" code tags & not the "xls" tags.]

@Fluff thanks for catching that.

Any idea how to do similar for the file name?

 

[Fluff]

I know of no way to get the file name with Excel online.