Convert formatted text to html code

Hi guys, i was wondering if someone can help me with this.
i have a catalog of products that im advertising on my website. my supplier sends me the file in excel format with descriptions of the items. i would like to know if its possible to convert the formatted text with colored fonts, bold, italic, etc in one cell into html code in the next cell. so for example

This Product is amazing
Click here for amazing specials
Thank you for your support

to this

<p>This Product is amazing <br />
Click here for amazing specials <br />
Thank you for your support<br />
</p>

How about this?

if your data start from A2 put this in B1:

Formula:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Unfortunately that doesn't work
if i paste directly from word into one cell in excel it only displays <br /> on the last item.
the formatted text that im copying has line breaks in between, certain fonts are bold, italic, etc
can this code be eddited so that it can pick up the various formats

What if you first paste it in notepad?

if i paste it into notepad it will make it into plain text, i dont want it to be plain text, i need it to be formatted with the various line breaks in certain areas, some text must be bold, others italic colored in red, etc.
can it be done?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Thank you for all your help. i really appreciate it. attached please see image