Workaround for sheet name in formula with Excel Online

[Florent RALINCOURT]

Hi there !

I used an Excel File that used the CELL function in order to extract the sheet's name. But the CELL function does not exist in Excel Online. Could you help me find a workaround to extract the sheet's name without the CELL function, that works in Excel Online ?

Kind regards

Flo

[#2]

@Florent RALINCOURT 

See the reply by Bloggs20 near the end of the following discussion:

workbook and sheet name via formula 

[#3]

@Florent RALINCOURT 

As Hans already replied, this is discussed in workbook and sheet name via formula.

At the end, you will find a new addition (by me [smile]) on how get the worksheet name without VBA and without hidden sheets, exploiting FORMULATEXT on the formula of the cell itself.