Jaafar Tribak
Well-known Member
- Joined
- Dec 5, 2002
- Messages
- 9,721
- Office Version
- 2016
- Platform
- Windows
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 :
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.
I have this formula in a cell to return the name of the sheet where the cell containing the formula is located :
Code:
=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.
Last edited: