How do I stop MS Excel from parsing html that I'm pasting in? Currently
I'm trying to paste in raw HTML code and it's reading the HTML and
formatting my input based on this (i.e. moving to the next row in teh
column whenever it encounters a < br ).

I don't fancy clicking into the edit box for each cell, as there's over
600, and it's too long to fit in a formula (900+ characters per cell).

Thanks.