I have the following problem - I have an Excel Sheet with undefinied number of rows.
I want to insert a forumula ( right(A2)… ) in every row, but when I use the action item for each row and write cell I receive the following message in Excel row =NAME?? and in the second, third,… row the formula is the same as in the first row
How can I manage to insert and activate the formula and to change it in the other rows?
Have you tried writing the formula manually to excel and see it works? This error usually comes when there is an issue with the formula-like syntax.
I tried the english formula: =RIGHT(A2,8) and its working.
The error message tells you you should use “Kommas” => " , " to split parameters. I know that in German Excel we use semicolons " ; " to split. Try changing that first, after that I would try to use English formulas.