title: VBA, search in column for specific character, extract string upto that character
body: <p>In a specific column, I want to search for a specific character in cells...say "(" or "/". Once this character is found in a cell, I want to extract the part from the beginning of the string upto the point that this character is found, in the cell adjacent to it.</p>
  
  <p>E.g. a few values in the column could look like -</p>
  
  <pre><code>Samsung (india)
  Samsung/Dhamal
  Blackberry (chikna)
  Blackberry/Kala Anda
  iPhone - egypt
  iPhone 5 * yeda
  </code></pre>
  
  <p>The output will look like -</p>
  
  <pre><code>Samsung
  Samsung
  Blackberry
  Blackberry
  iPhone
  iPhone 5
  </code></pre>
  
  <p><strong>NOTE:</strong> The cell values in that specific column, are not static, have no pattern, may contain other special characters as well, are not of a specific length.</p>