title: Excel Formula to Sum Delimited Values in Cells
body: <p>I have two general columns of text stored in Excel, where each cell contains numbers delimited by a semicolon (delimited only if multiple numbers present).
  The two Excel columns always have the same number of values delimited.</p>
  
  <p>I'm trying to figure out how to sum (subtract) each value to form a delimited list in another column, especially using Excel Functions only (e.g. no VBA if possible). </p>
  
  <p>How can I do this? I'm missing VBA's split function from the Excel Formulas.
  <a href="https://i.stack.imgur.com/niKr9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/niKr9.png" alt="What Excel formulas can achieve the Desired Result?"></a>
  Note: Value - Offset = (Desired Result)</p>