"Cell" function accross Languages (No VBA)

[Jaafar Tribak]

Hi dear members,

I have this formula in a cell to return the name of the sheet where the cell containing the formula is located :

=RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename"),1))

Now, if I open the workbook in an edition of excel other than English, the formula errors out because the info_type argument of the Cell function is language dependent.

I guess this question must have been asked before : Is there a clever workaround to solve this ? (Without vba).

I don't think there is an excel function that returns the language excel uses so I could incorporate it to the formula ?

Thanks.

 

[Jaafar Tribak]

I asked too soon

ISERROR should solve the problem