How To Split symbols and write into separate column/row?

[Alfred_Gan (Fred)]

Dear All,

Possible if i have a scenario for where i want to to split the symbols and write into new columns like below

Before

After split it should look like this

Test Example.xlsx (16.6 KB)

i tried several features like excel application scope>split string>for each>write line
or text to columns.

Need your expertise to advise which are the most simple feature/expression editor code, and way to achieve this.

[Yoichi]

Hi,

Hope the following sample helps you.

FOrEachRow case

LINQ case

Sample20221114-4 (2).zip (20.1 KB)

Regards,

[Alfred_Gan (Fred)]

Hi @Yoichi ,

It works perfectly!!

Thank you so much for help!!