Split excel column

I have a file in excel that I need to give split to separate the columns, could anyone send me an example of how to do this?
Thank you very much in advance

for example I need (Número da Fatura) to be in the A, (Status da Fatura) in column B and so onPasta1.xlsx (10.9 KB)

You can use a combination of “Get row item” and “Assign” to do this;

Get the row, output it as “Number” and assign number = number.Split({" "},stringSplitOptions.RemoveEmptyEntries)(0)

Write this to a new datatable in column A, get next row item, output that as “Status” and assign status = number.Split({" "},stringSplitOptions.RemoveEmptyEntries)(1) etc.

Not sure it’s the best way, but it’ll achieve what you’re looking for I think.

1 Like