title: How to extract a substring using regex in Goo
body: <p>I have a table that has the columns_text content.  <br />
  The &quot;word_list&quot; column is from another table and <br />
  I would like to extract from the &quot;columns_text&quot; just the part that matches the word in the word_list. <br />
  So the result will be just the word that matches the &quot;word_list&quot; column<br />
  Is it possible to do it on Google Sheets with formula?</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">word_list</th>
  <th style="text-align: center;">columns_text</th>
  <th style="text-align: right;">result</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">Milk</td>
  <td style="text-align: center;">AB - 01 - Specific - Dmodel - Milk</td>
  <td style="text-align: right;">Milk</td>
  </tr>
  <tr>
  <td style="text-align: left;">Apple</td>
  <td style="text-align: center;">AB - 01 - Specific - Dmodel - Delta Milk</td>
  <td style="text-align: right;">Milk</td>
  </tr>
  <tr>
  <td style="text-align: left;">Orange</td>
  <td style="text-align: center;">text-milk-dmodel-specific</td>
  <td style="text-align: right;">Milk</td>
  </tr>
  <tr>
  <td style="text-align: left;">Beans</td>
  <td style="text-align: center;">dmodel_milk_specif_text</td>
  <td style="text-align: right;">Milk</td>
  </tr>
  <tr>
  <td style="text-align: left;">Rice</td>
  <td style="text-align: center;">Text / Dmodel / MILK / SPECIFIC</td>
  <td style="text-align: right;">Milk</td>
  </tr>
  <tr>
  <td style="text-align: left;">Wine</td>
  <td style="text-align: center;">text specific milk model</td>
  <td style="text-align: right;">Milk</td>
  </tr>
  <tr>
  <td style="text-align: left;">Water</td>
  <td style="text-align: center;">AC - 04 - Specific - Dmodel - Apple twist</td>
  <td style="text-align: right;">Apple</td>
  </tr>
  <tr>
  <td style="text-align: left;">Juice</td>
  <td style="text-align: center;">AB - 01 - Specific - Dmodel - The Apple</td>
  <td style="text-align: right;">Apple</td>
  </tr>
  <tr>
  <td style="text-align: left;"></td>
  <td style="text-align: center;">text-apple-dmodel-specific</td>
  <td style="text-align: right;">Apple</td>
  </tr>
  <tr>
  <td style="text-align: left;"></td>
  <td style="text-align: center;">Text / Dmodel / APPLE / SPECIFIC</td>
  <td style="text-align: right;">Apple</td>
  </tr>
  </tbody>
  </table>
  </div>