Cell has a list wrapped in html. Split list into 2 separated by special character

[JCountryman]

I have an excel file that has a list of items that are wrapped in html code. I would like to split it into 2 groups and move them into 2 different cells and separate the list with a special character (such as >) that I can search and replace later on.

Please see attachment. I have put notes in the excel file

[#2]

@peiyezhu is there a way I can run your script on my own to make these changes? I am not that familiar with the coding you have done

[#3]

1.56 dNw:/ https://v.douyin.com/S4W65KD/ 复制此链接，打开Dou音搜索，直接观看视频！

Have you tried the online tool?

Only copy and paste to finish the task.

please check the video for detail operation.

[#4]

@Patrick2788 were you able to give this any more thought?

[#5]

@Patrick2788 

What if we use BS4 to get clean text easily?

[#6]

We can use BS4 to clean this.

[#7]

@JCountryman 

According to @Syed_Asad_Abbas , this is possible using BS4 which I believe he's referring to BeautifulSoup 4 which is a Python package.  I'll defer to the Python experts on this one.

[#8]

@Patrick2788 thank you for your help. @Syed_Asad_Abbas , I know nothing about BS4 and Python.

A key thing is that I am able to run this in excel so Im not sure the solution will work for me. Please let me know if I am incorrect