I'm trying to create a formula to work out the number of answers in a single cell. Each line in entered with ALT+Enter : [Sample of the data. Column A is imported data and Column B is the result.][1]


  [1]: http://i.stack.imgur.com/oJntG.png