M Language Syntax problem from Excel 2013 to 2016

[Anonymous]

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.

[v-yulgu-msft · Accepted solution]

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

[Anonymous]

thanks, i will try there.

Bye

Luca