title: How do you cast an integer to a string in Excel's PowerQuery
body: <p>I have a PowerQuery which pulls back two columns; one a <code>Number</code> (an integer), the other <code>Text</code> (a string).
  I'd like to create a custom column which concatenates these.</p>
  
  <p>It seems this should work: <code>="(" &amp; ([Value] as text) &amp; ", " &amp; [Description] &amp; ")"</code></p>
  
  <p>But this returns error <code>Expression.Error: We cannot convert the value 1 to type Text.</code></p>
  
  <p>NB: This question relates to the PowerQuery editor (i.e. the <code>M</code> language); not regular Excel worksheet functions.  The worksheet function to achieve what I'm after would be <code>=concatenate("(", A2, ", ", B2, ")")</code>, where A2 is Value and B2 is Description.</p>