Forum Discussion
Solved
Generating an Formula using concatenation in excel
Hi There, I am planning to generate a formula using concatenation operation in excel and it actually works but the only issue is it’s not executing it just gives the generated formula as output i...
This uses the XLM command EVALUATE within Name Manager where it works correctly just as HansVogelaar 's solution. With 365 the process can be taken a step further and the name can be a Lambda function.
EVALUATEλ = LAMBDA(formula, EVALUATE(formula))The sole advantage is that EVALUATEλ can be reused with multiple strings.
Looks pretty understandable. Since I do not have access to Office Script, I tried typing into a Script Lab code window but it showed ExcelScript as an unknown namespace. 😞
ScriptLab has bit different interface. Not sure how exactly to run above in it, never used ScriptLab, only read about.
Know no reasons why Microsoft doesn't make OfficeScript available for consumers, at least on some subscriptions.
- One of the strengths of Excel is its universality. I have doubts about committing serious effort to getting up to speed on a topic if I cannot communicate it to others and, worse, I may in due course lose access to my own work!