Formula to work out the number of answers in a single cell
<p>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.</p>

<p>Column A is imported data and Column B is the result.</p>

<p><a href="http://i.stack.imgur.com/oJntG.png" rel="nofollow">Sample of the data</a></p>