using on each newline

I have following patte in every single cell in the coloumn in Libre Calc -

Spec One: This is one
Spec Two: This is spec two
Spec Three: This is spec three

Is there any way to convert this to -

<li>Spec One: This is one</li>
<li>Spec Two: This is spec two</li>
<li>Spec Three: This is spec three</li>

The entry was done using 'Ctrl+Enter' after every spec. TIA.

Recent Questions...