Forum Discussion
Translate excel formulas from Swedish to English
Hi, My colleague has a Swedish Excel and I have a US Excel. She took my excel file with lots of formulas to make some edits in just the numbers. Excel translated all the formulas to Swedish but w...
you could use this https://en.excel-translator.de/translator/
Thanks. I was hoping there was a setting or import I could do since the spreadsheet has several thousand formulas of different kinds.
- Excel stores native formulas in the file regardless of locale language setting. a file saved in Excel with Swedish locale setting, should normally open in Excel with English regional language setting and the functions should not have any issue. sometimes the functions would not convert, if the file is opened in protected mode.
If the issue still persists then your Excel workbook may not have hundreds of different functions used.
so lets say that a Excel function "SEARCH" in Swedish "SÖK" and you still see the Swedish function name instead of the English one, then you can use the FIND&REPLACE to replace the functions back to English. below link gives the list of Swedish and English excel function names.
http://www.piuha.fi/excel-function-name-translation/index.php?page=english-swedish.htmlThe only logical exceptions is formulas within INDIRECT()
