title: google spreadsheet select a column with substring
body: <p>I have a spreadsheet A, and use import/query command to generate a spreadsheet B, but I wish the selected column display only first 7 characters.</p>
  
  <p>e.g. A has a 1234567890abcdef string, but after apply the select command such as:</p>
  
  <pre><code>=query(importrange("docid","sheetname!A:M"),"select Col1")
  </code></pre>
  
  <p>Then wish the output is 1234567 (first 7 characters) but not the whole string 1234567890abcdef.</p>
  
  <p>I wish below command can work but actually not:</p>
  
  <pre><code>=query(importrange("docid","sheetname!A:M"),"select left(Col1,7)")
  </code></pre>