title: How do I split a cell and create new concatenated field?
body: <p>So I have fields like <code>Fruit-Apple-25</code> , <code>Vegetable-Tomato-22</code> in a row. Can I create a new field where I can name it as <code>Fr_Grp_App</code> , <code>Vg_Grp_Tm</code>. What I am using now is to just select if its apple or tomato but not add the other prefixes. How can I do that.</p>
  
  <p><code>if(not(iserror(find("Apple",D3))),"Apple",if(not(iserror(find("Tomato",D3))),"Tomato")</code></p>
  
  <p>So if its Fruit then it should be Fr in the prefix and if its Vegetable it should be Vg as prefix</p>