title: How to find partial matching elements in libreoffice spreadsheet?
body: <p>In an excel spreadsheet I have a column (column A) with e.g. the following elements:</p>
  
  <pre><code>Audi, VW, BMW Group, Toyota
  </code></pre>
  
  <p>Now I can do a search of an element like this</p>
  
  <pre><code>match("*"&amp;b1&amp;"*", a1:a5,0)
  </code></pre>
  
  <p>which will either return the relative number of where the element is found or <code>N/A</code>. So, for example, if I put <code>Audi</code> in the cell B1, the formula will return '1', and it I put 'BMW' in the cell B1, the formula returns the value '3' (since the formula uses wildcards). </p>
  
  <p>However, in a libreoffice spreadsheet this does not work. When putting the term 'BMW' into cell B1, the formula here returns 'N/A'. How to change the formula to have it work the same as the excel spreadsheet?</p>