title: Can I separate text in a column based on there being either one or more than one word?
body: <p>I have a column headed 'Name' in sheet 'Imported'. This is auto populated with either just a first name or a full name. I would like to move the data from this column into column T of another sheet called 'Road MT" if it's a full name or column U of that sheet if it's only a first name. </p>
  
  <p>Currently the data from the Name column goes into column T of the other sheet and if required I manually move it to column U.</p>
  
  <pre><code>    var spreadsheet = SpreadsheetApp.getActive();
        spreadsheet.getRange('T2').activate();
  
   spreadsheet.getRange('Imported!J2:J').copyTo(spreadsheet.getActiveRange(), 
      SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
      }
  </code></pre>