Separate Bullet list into many row

Hi all,

Could you please teach me how to separate bullet list into many rows:

Here’s a quick example:


I have tried Split but I don’t know the key: Charater(10).
Thank you for teaching me.

I have enjoyed using excel but I am trying to replace Coda with excel.
So far, I believe i can do it with your support.

Dear @Loi_Quang_Ho,

Please find below the relevant references to the formulas and Unicode characters used

As you can see the formula:

Meaning that after the “line feed” the text is split

Does this explain what you are looking for.


Hi @Jean_Pierre_Traets

Thank you so much, that’s what I really need.