title: Split a string (cell) in Excel without VBA (e.g. for array formula)
body: <p>I have data in an Excel spreadsheet with delimited strings. For simplicity, think of something like <code>"4#8#10"</code>, with an arbitrary number of pieces. </p>
  
  <p>Is there any way to split this into an array for use with an array formula? For example, something like <code>SUM(SplitStr(A1,"#"))</code>. (This does not work - it just returns <code>"4"</code>.) </p>
  
  <p>Is there a good way of approaching this? My ideal solution would end up with an array, as if the user entered <code>{4,8,10}</code> for use in array formulas. </p>
  
  <p>The application of my sheet does not allow for delimiter-based text to columns and summing that. I would prefer to not use VBA if possible as I will not be the primary consumer of the sheet. </p>
  
  <p>Thanks,
  Terry</p>