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...
Patrick I appreciate your response. Instead of a list can we set it up so that it is all one line separated by >. See column C and 7. Highlighted in red. See attached
Yes, I've revised my post above with new formulas and a new workbook.
Patrick Im not having much luck trying to emulate what you created. Could you please take a look
peiyezhu for the plan and option we would need a special character ">" in-between the each bullet in the "Plan" and "Option" cells.
Is there a way to run a script so this is automated? There will be a total of 8-10 Long descriptions.
Let me know if this can be done
- 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?
