Text in Excel function to translate

Question

Hello, 
 Trados 2019 don&acute;t show me text for translation in this Excel function "=CONCATENATE(" Eingeschr&auml;nkte Sichtpr&uuml;fung ";ROUND(E12;4)*100;"%")" Any suggestion how to solve it? 
 ED

Paul · Answer

Eugen Drgoň 
 The way to tackle this is have the text in a cell somewhere else and call it. For example, put the text Eingeschr&auml;nkte Sichtpr&uuml;fung into cell A1 in another worksheet ( TranslatedFormulaeTexts in this example) and then reference this text in the concatenation formulae as opposed to making it part of the formulae itself:

Then you would translate the text in TranslatedFormulaeTexts!A1 and your formulae would automatically update in the target file. 
 You cannot translate Excel formulae.

Trados Studio > 1. Trados Studio

Text in Excel function to translate