Forum Discussion
M Language Syntax problem from Excel 2013 to 2016
Hi All,
i cant figure out why i am getting this problem after passing from excel 2013 to 2016.
The syntax seems correct and also PQ editor says that it is fine but then the step is considered wrong.
=Text.Select(Text.Start([IdRisorsa],2),{"A".."Z"})
The formula worked perfectly in excel 2013 then, with the passage to the new version, it started giving error. The error is "Expression.Error: The name 'Text.Select' wasn't recognized. Make sure it's spelled correctly."
Moreover the exact same formula works on another PC. I cant understand what is going on. If i insert the formula in formula bar everything is ok.
pls help really important.
Hi Anonymous ,
I tested above M function in my Excel 2016, it worked fine.
This problem looks more related to Excel itself. I would suggest you post a thread on Excel forum for help.
Best regards,
Yuliana Gu
2 Replies
v-yulgu-msftMicrosoft Employee
Hi Anonymous ,
I tested above M function in my Excel 2016, it worked fine.
This problem looks more related to Excel itself. I would suggest you post a thread on Excel forum for help.
Best regards,
Yuliana Gu