Cleaning a spreadsheet

Hi guys,

I have a spreadsheet containing hundreds of product names in a column and the description in the next column.

My problem is this. The description has a seperator <Br/> in between the descriptive phrases in a line. Effectively this means that the next part of the descriptive text should be below the previous.

So instead of removing the <Br/> manually and then hitting Alt + Enter to get the next description in below, is their a formula to do this?

I am attaching a sample!

Fugly