Forum Discussion
Cell has a list wrapped in html. Split list into 2 separated by special character
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...
That sample has different terms within the <> and listed in a different order so the TEXTBEFORE/TEXTAFTER is failing. "Includes:" and "Optional" can be used as delimiters to pull the text for Plan and Benefits then it becomes a matter of cleaning out the other stuff. I'll give it some thought.
Patrick2788 were you able to give this any more thought?
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.
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