Replacing bullets with html tags for csv load

[FuriousD]

I recently needed to add bullet points to a file and someone on here was able to help. Turns out we actually need to add html tags to the file for upload and I'm hoping there is a way for us to use a formula to replace bullets with the <li> </li> tags to have bullets load.

Any ideas? I need to maintain the intro paragraph and lines, which is leading me to more of a find/replace solution without bullets. Thanks in advance

Current:	What I need excel to display:
Your text goes here. Sample text showing paragraph intro followed by bullet items. Line 1 Line 2 Line 3	Your text goes here. Sample text showing paragraph intro followed by bullet items. <li> Line 1 </li> <li> Line 2 </li> <li> Line 3 </li>

 

[Sufiyan97]

You're welcome.