title: how to use [left] [Right] to split comma separated values more than 2?
body: <pre><code>A1= 831  , 12673 , 12286 , 5974 
  </code></pre>
  
  <p><code>=LEFT(A1,FIND(",",A1,1) - 1))</code> it returns 831 thats OK.</p>
  
  <p>If, <code>=Right(A1,FIND(",",A1,1) - 1))</code> returns 5974</p>
  
  <p>But how to get middle 2 values like 12673 &amp; 12286 ??</p>
  
  <p>Note- My values do not have fixed length, some of them are 4 digit, some 3 and some 5.</p>