title: Excel "UnCONCATENATE"/explode in function / Convert cell into array
body: <p>I am trying to "Unconcatenate" a string in Excel 2010. Yes, I know that is not a real word. So pretty much; I have a cell that can not be split into multiple columns the cell looks like this:</p>
  
  <p>Item 1, Item 2, Item 3</p>
  
  <p>Now this cell may have 0-? items. I am wanting to compare that one cell against a column in another sheet. I believe I would need to use the match function to do this, but I need that first cell to be converted into an array in a function with the delimiter as the comma. 
  So far I have =MATCH(<strong><em>Each item in cell</em></strong>, SHEET2!A:A, 0)</p>
  
  <p>Any help would be nice. I am aware of =Left and =Right, but I do not think these will work because the number of items in each cell may not be the same. Thanks</p>
  
  <p>Edit:</p>
  
  <p>Detailed discription:
  In my first sheet I have a dropdown box. When you choose items it does a vlookup on sheet 2 on this item. When this happens I want it to also check if cell E in that row (item 1, item 2, item 3) match any of the individual cells in a column in sheet 3 </p>