title: Splitting the text of a single cell and using it as source for a validation list without VBA
body: <p>Im trying for some hours already to split a text cell into a usable object to the validation list.</p>
  
  <p>The cells today are populated by 3 or more (N) comma (I can change that to semicolons, pipes...) separated values like "1,2,3" or "5,test,8,new"</p>
  
  <p>I want to transform that into a validation list with N different values.</p>
  
  <p>In the following post there is a formula that splits a string into and array, but I have not managed to use it as source:
  <a href="https://stackoverflow.com/questions/25316094/split-a-string-cell-in-excel-without-vba-e-g-for-array-formula/25316426">Split a string (cell) in Excel without VBA (e.g. for array formula)</a></p>
  
  <p>Is it possible to create a Dynamic Range from splitting the cell text and feeding it into a 'combobox' (validation list).</p>
  
  <p>Another similar example of what I am looking for but without VBA:
  <a href="https://stackoverflow.com/questions/28324004/excel-dynamic-drop-down-using-comma-delimited-data">Excel Dynamic Drop Down Using Comma Delimited Data</a></p>
  
  <p>What am I doing wrong here? Thanks for reading this far.</p>