How to split words and insert that data into columns in excel?

split

How to split to get sr.no in 1st column ,name of participant in 2nd column,department and designation in 3rd column,official address in 4th column,contact details in 5th column,email id in 6th column as headers 7 data below it

Can anyone guide and provide links for vbscript expressions for activities in uipath?

you can use generate data table, where you can give text as input, space as column separator and new line as newLineseparator