Forum Discussion
Unexpected error with LET function
For your information, I also sent a frown. People at Microsoft can reproduce the bug, hope will be fixed one day.
Please note this function is in Beta mode, that means bugs could appear in some scenarios, plus function behaviour on time of general availability could be slightly different from what we have now. That's normal process, so far we use the function (as any other beta ones) on our own risk, even if such risk is relatively small.
Looks like a bug, I'd suggest you to send a frown through File->Feedback.
By the way, number to text formula with LET() you may find in discussion here https://techcommunity.microsoft.com/t5/excel-blog/announcing-let/ba-p/1233572
Hi SergeiBaklan:
Thanks for your reply!
I went through the number to letter formula in the discussion and found it very helpful!
I rewrote mine (for Spanish numbers) in a similar way, but I keep getting the same error.
I already wrote to Excel Feedback and I am still waiting for their response.
Sad not to be able to enjoy the formula.
Perhaps you may submit the file where this function returns an error, it'll be easier to check what is wrong.
The only point, from the time of publishing abovementioned sample of the forum there was introduced the change in function - it doesn't support dots within names any more. Other words, with name as H.txt you'll have an error, use Htxt instead or any other name without the dot. Correct formula is in attached file. But that's another issue, not as in initial post.
Hi, SergeiBaklan:
Just tried to open the file you sent but I get the same error.
I'm attaching my file, so you might want to check it out.
Thank you!
For your information, I also sent a frown. People at Microsoft can reproduce the bug, hope will be fixed one day.
Please note this function is in Beta mode, that means bugs could appear in some scenarios, plus function behaviour on time of general availability could be slightly different from what we have now. That's normal process, so far we use the function (as any other beta ones) on our own risk, even if such risk is relatively small.