title: To regextract keywords in between [ ] but has different data variations
body: <p>i have trouble running into this formula when i have slight different variations of data. The idea is to capture the brand in between square bracket but some contains &quot; &quot; inside the square brackets [] contains the brand name. As per the screenshots, you will see the variations of the data.</p>
  <p><strong><a href="https://docs.google.com/spreadsheets/d/1bwXji2r5Vhb1gw0Q2AONUvrpI_5cCQbHozgma02eYgk/edit?usp=sharing" rel="nofollow noreferrer">Here is the link to the trix:</a></strong></p>
  <p><a href="https://i.stack.imgur.com/UwuHi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UwuHi.png" alt="screenshot" /></a></p>