title: Extract (unconcatenate) cell value in Excel
body: <p>I wish to split a cell value
  The cell value will be in the form of <code>###x###</code>
  Where <code>#</code> is a <code>0</code>-<code>9</code> number.
  Also, the number of places can vary so it could be <code>###x####</code> or <code>####x####</code>
  This makes me unable to use <code>LEFT</code> or <code>MID</code> function</p>
  
  <p>The common thing is the two numbers I want to extract separately are joined by <code>'x'</code></p>
  
  <p>I tried using search function but could not find an answer.</p>
  
  <p>How can I do this? With or without VBA? Thanks!</p>