"Cell" function accross Languages (No VBA)

Jaafar Tribak

Well-known Member
Joined
Dec 5, 2002
Messages
7,843
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 :
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:

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Jaafar Tribak

Well-known Member
Joined
Dec 5, 2002
Messages
7,843
Office Version
2016
Platform
Windows
I asked too soon :)

ISERROR should solve the problem
 

Watch MrExcel Video

Forum statistics

Threads
1,099,367
Messages
5,468,210
Members
406,571
Latest member
carrie1994

This Week's Hot Topics

Top