title: Insert blank column in Excel with values based on other column data
body: <p>I have a spreadsheet that comes to me with a column that contains FQDN's of computers. However, filtering this is difficult because of the unique names and I ended up putting in a new column next the FQDN column and then entering a less unique value based on that name. An example of this would be:</p>
  
  <p>dc01spmkt.domain.com
  new column value = "MARKETING"</p>
  
  <p>All of the hosts will have a 3 letter designation so people can filter on the new column with the more generic titles. </p>
  
  <p>My question is: Is there a way that I can script this so that when the raw sheet comes I can run the script and it will look for values in the old column to populate the new one? So if it finds 'mkt' together in the hostname field it writes MARKETING, or if it finds 'sls' it writes SALES? </p>