Using LET Function

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!!!

Thank you for letting us about this issue!

Please download the fixed build here:

https://www.libxl.com/download/build/libxl-win-4.6.0.4.zip