将包含换行符的HTML字符串粘贴到单个Excel单元格中

I'm trying to insert a HTML/RTF formatted text into a single Excel cell, preserving text formatting (colour, bold, italic etc). The problem is that if the text contains line breaks (< br>), parts of the text between the breaks get inserted into separate cells (see attached screenshot). I've tried using I'm trying to insert a HTML/RTF formatted text