Hello Everyone,
I am attempting to write this formula into a cell:
LET(prefix,C2,text,C3,L,LEN(prefix),IF(LEFT(text,L)=prefix,CHAR(65+L)&MID(text,L+1,LEN(text)-L),"A"&text))
When I attempt to open the file in Excel, I get a popup warning that there was a problem with the formula.
Does anyone have an example or some pointers when it comes to this issue?
I have tries WriteFormula and WriteFormulaStr with no success.
LibXL 4.6.0.
Thank you!!!