Text.Middle Basic Formula Power Query

Lina Quintana 21 Reputation points

I´m trying to use the formula Text.Middle for a custom column, but get an error of expression.

Expression error: the name Text.Middle is not recognized. Make sure it is spelled correctly.

I´ve checked the spelling and theres no issue. What am I doing wrong?


I´ve used other text formulas with no issue whatsoever. For example Text.PositionOf as shown:


Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,630 questions
0 comments No comments
{count} votes

Accepted answer
  1. Ehren (MSFT) 1,781 Reputation points Microsoft Employee

    It's likely that you're using an older version of Power Query. Can you share your PQ version? If you installed it as an addin, please upgrade the addin to a more recent release. If it came as part of Excel, you will need to update Excel in order to get an updated version of PQ.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Lina Quintana 21 Reputation points

    I have Excel 2016 which came with PQ already. I wil try upgrading my excel. Thanks.